SQL查看表中重复数据

来源:互联网 发布:linux grep java 编辑:程序博客网 时间:2024/06/06 15:36

sql如下:

select column1,column2,count(*) from tableName
group by column1,column2
having count(*)>1
order by count(*) desc

0 0
原创粉丝点击