SELECT TOP 10 *
FROM (SELECT COUNT(UserId) AS diancms, UserName, userid
FROM D_U_Article
WHERE (DATEDIFF([day], AddTime, GETDATE()) <= 7) and LanMu_Id=2
GROUP BY UserId, UserName) DianCMSTable
ORDER BY diancms DESC
飘飘浮云
路旁的落叶
回复于 2011/4/20 16:57:00
#2楼
SELECT TOP 10 *
FROM
(SELECT COUNT(UserId) AS diancms, UserName, UserId FROM D_U_qqrwb WHERE (DATEDIFF([day], AddTime, GETDATE()) <= 7)
AND sslm_Id=2 GROUP BY UserId, UserName)
DianCMSTable INNER JOIN D_User
ON DianCMSTable.UserId = D_User.UserId
ORDER BY DianCMSTable.diancms DESC
加强版