日期:2014-05-17 浏览次数:20932 次
select * from table where rowid not in (select max(rowid) from table group by A,B,C) 如果要全部显示出来,考虑用group by having select * from table where A,B,C in ( select A,B,C from table group by A,B,C having count(1) > 1 )
------解决方案--------------------
上午的回帖 没达到效果么?