看看像
DECLARE @Sales TABLE( CUS_ID INT, PRODUCT VARCHAr(20), AMOUNT FLOAT)INSERT INTO @Sales SELECt 12,'A', 2.50 INSERT INTO @Sales SELECT 12,'B', 5.80 INSERT INTO @Sales SELECT 24,'A', 10.00 INSERT INTO @Sales SELECT 24,'B', 30.00;WITH Vals AS ( SELECT cus_id, product, amount, 1 DisplayOrder, SUM(amount) OVER(PARTITION BY cus_id) OrderTotal FROM @Sales UNIOn ALLSELECt cus_id, 'Total' AS product, SUM(amount), 2 DisplayOrder, SUM(amount) FROM @Sales GROUP BY cus_id)SELECt cus_id, product, amountFROM ValsORDER BY OrderTotal DESC,cus_id,DisplayOrder, product
