sql 语句查询一个表中不同的记录有多少条？

2022-09-01 18:08

例如：表明 T 字段 id adress 谢谢

2022-09-01 20:17

select count(distinct id , adress) from t

是指 id,address都不相同吧

SELECT COUNT(1)
FROM (select DISTINCT * from T) TEMP

select count(distinct id , adress ) from t

select count (distinct adress )from T