27,579
社区成员
发帖
与我相关
我的任务
分享
select top 10 UID,APPID,AddDate,sum(PvSum)PvSum ,row_number() over(order by AddDate desc,sum(PvSum) desc)row from SummaryData group by UID,APPID,AddDate
--try
select top 10 UID,APPID,AddDate,sum(PvSum)PvSum ,
row_number() over(order by AddDate desc,sum(PvSum) desc)row
from SummaryData
group by UID,APPID,AddDate