sql查詢某字段的相同值:
SELECT * FROM table WHERE col in (SELECT col FROM table GROUP BY col HAVING COUNT (col) >1);
順帶說(shuō)一下where和having:
select * from table
where ···(只能對(duì)分組前的屬性進(jìn)行篩選)
group by ···(按某個(gè)字段分組)
having ···(只能對(duì)分組后的每個(gè)組的整體屬性進(jìn)行篩選,用聚合函數(shù)體現(xiàn))
--不使用group by就默認(rèn)表的整體為一組
實(shí)例:
查詢出重復(fù)記錄
select * from 數(shù)據(jù)表 WHERE 重復(fù)記錄字段 in ( select 重復(fù)記錄字段 from 數(shù)據(jù)表 group by 重復(fù)記錄字段 having count(重復(fù)記錄字段)>1)