3.0 SQL Helper

1,sql去重复记录 distinct

2,sql查询重复数据

  select id, name, memo from A where id in (select id from A group by id having count(1) >= 2)

posted @ 2015-02-03 10:31  10:00  阅读(114)  评论(0)    收藏  举报