急求SQL语句!!@
用SQL语句实现,查询数据库中重复的记录,怎么能查询出来?
------解决方案--------------------select 字段,count(*) from 表 group by 字段 having count(*)> '1 '
------解决方案--------------------如果查全部记录.假设重复记录字段为ID
select * from tb where id in (select id from tb group by id having count(*)> 1)
------解决方案--------------------一楼正解:select 字段,count(*) from 表 group by 字段 having count(*)> 1