2012年7月4日
笔记
摘要： WITH #temp AS (SELECT ROW_NUMBER() OVER( ORDER BY SUM(nReceiveVolume) desc) AS indexof,SUM(nReceiveVolume) AS sumVolume,vcCustID FROM Ord_PurchaseOrder GROUP BY vcCustID) SELECT * FROM #temp WHERE vcCustID='201010192292000844' 阅读全文
posted @ 2012-07-04 18:52 liuliu_刘刘 阅读(119) 评论(0) 推荐(0)