select idrow=identity(int,1,1),[书籍名称],[全年点击量]
From
(
SELECT view_MonthDemand.书籍名称 as [书籍名称],sum(view_MonthDemand.月点击量) as [全年点击量]
from view_MonthDemand
where view_MonthDemand.DATE_YEAR='2007年' and view_MonthDemand.DATE_MONTH='01月'
group by view_MonthDemand.书籍名称
order by view_MonthDemand.全年点击量 desc
) t
From
(
SELECT view_MonthDemand.书籍名称 as [书籍名称],sum(view_MonthDemand.月点击量) as [全年点击量]
from view_MonthDemand
where view_MonthDemand.DATE_YEAR='2007年' and view_MonthDemand.DATE_MONTH='01月'
group by view_MonthDemand.书籍名称
order by view_MonthDemand.全年点击量 desc
) t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货