moss_tan_jun

:: :: :: ::

::

查询重复数据的SQL语句

Posted on 2010-09-23 22:40 moss_tan_jun 阅读(280) 评论(0) 编辑收藏举报

select column1, column2

from TB

where column1 in

(select column1, column2 from TB

group by column1, column2

having(count(*)>1))

刷新页面返回顶部