調(diào)用會(huì)員在某個(gè)數(shù)據(jù)表發(fā)帖量的排行,沒(méi)有發(fā)布信息的會(huì)員按照會(huì)員ID排序
代碼如下:
select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder
from phome_enewsmember u group by u.userid order by myorder desc,u.userid asc
效果圖如下:
此文由 網(wǎng)站目錄_網(wǎng)站網(wǎng)址收錄與提交入口 編輯,未經(jīng)允許不得轉(zhuǎn)載!: