查询重复数据的SQL语句
时间:2010-09-22 来源:Rusteel
select column1, column2
from TB
where column1 in
(select column1, column2 from TB
group by column1, column2
having(count(*)>1))
相关阅读 更多 +
时间:2010-09-22 来源:Rusteel