.NET 追寻足迹

摘要： WITH tagTab AS(SELECT YearMonth, pm=RANK() OVER(PARTITION BY YearMonth ORDER BY amount DESC) FROM SaleTab)SELECT * FROM tagTab WHERE pm<=5　开窗函数：http://technet.microsoft.com/zh-cn/library/ms189461(v=sql.105).aspx 阅读全文