日期:2014-05-17 浏览次数:20599 次
select * from t
where (A,B) in (select A,B from t group by A,B having count(*) > 1)
select * from t
where (A,B) in (select A,B from t group by A,B having count(*) > 1)
and id not in (select min(id) from t group by A,B having count(*) > 1)