摘要:1 -- 利用临时表求查值2 CREATE TABLE #tab ([user_id] INT,[fengshu] INT)3 INSERT INTO #tab([user_id],[fengshu]) SELECT [user_id],SUM(fengshu) FROM dbo.score WHERE kemu='yuwen' GROUP BY user_id ORDER BY user_id DESC 4 INSERT INTO #tab([user_id],[fengshu]) SELECT [user_id],-(SUM(fengshu)) FROM dbo.score
阅读全文
06 2013 档案