摘要：
select * from 表名 a join (select ID,NAME from 表名 group by ID,NAME having count(*)>1) b on a.ID=b.ID and a.NAME=b.NAME order by a.NAME ,a.ID ID和NAME是要查询的重复字段 阅读全文
posted @ 2010-11-06 08:56 ykhi 阅读(5380) 评论(0) 推荐(0)
|
|
|
|
摘要：
select * from 表名 a join (select ID,NAME from 表名 group by ID,NAME having count(*)>1) b on a.ID=b.ID and a.NAME=b.NAME order by a.NAME ,a.ID ID和NAME是要查询的重复字段 阅读全文
posted @ 2010-11-06 08:56 ykhi 阅读(5380) 评论(0) 推荐(0) |
|
浙公网安备 33010602011771号