1.统计本周点击量 SELECT ResourceID,SUM(ClickCount) as ammout FROM KBHotClick WHERE (DATEDIFF(week, ClickDate,getdate()) = 0) GROUP BY ResourceID order by ammout desc