查找在一张表里的重复字段及该字段重复的次数,T-SQL如下:

来源:互联网 发布:淘宝店铺出租安全吗 编辑:程序博客网 时间:2024/04/29 23:04

Select title,count(title) as total

From [CurrentTable]

Group by title Having count(title)>1 Order by count(title) desc