类型:转载 责任编辑:asp.net 日期:2007/05/23
热门软件下载:
我想取出表中重复的, 相同的记录,请问怎么写sql语句啊
网友回答:
select * from ta3 group by ...having count(1)>1
select 字段,count(字段) from tab group by 字段 having count(字段)>1