8-12.sql

sql2000工程实践一书第8张源代码

USE Car
GO
SELECT 车型, 数量, SUM(金额 * 数量) AS 合计金额
FROM 销售记录
GROUP BY 车型, 数量 
WITH CUBE
GO