表格article按標題重復次數降序列表查詢(xún),返回title和title值的重復次數:
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
服務(wù)項目產(chǎn)品中心關(guān)于我們
© 2014- 廣西欽州市海燕信息科技有限公司 版權所有