查询表tsc-bzx中id是否有重复的纪录

[bruce20062006]

tsc_bzx表
ID
1
2
3
4
5
6


IF EXISTS(------)

查询表tsc-bzx中id是否有重复的纪录

[水族杰纶]

select * from tsc_bzx group by id having count(ID)>1

[SQL77]

SELECT ID FROM tsc_bzx GROUP BY ID HAVING COUNT(ID)>=2

[--小F--]

select id from tb group by id having count(id)>1