表格article按標題重復(fù)次數(shù)降序列表查詢，返回title和title值的重復(fù)次數(shù)：
status=1條件為article的列status
select top 3 tb1.* from (select title,count(*) as count from article where status=1 group by title) as tb1 order by tb1.count desc
表格article按標題重復(fù)次數(shù)降序列表查詢，返回title和title值的重復(fù)次數(shù)：
status=1條件為article的列status
select top 3 tb1.* from (select title,count(*) as count from article where status=1 group by title) as tb1 order by tb1.count desc