USE pubs
SELECT type, price, advance
FROM titles
ORDER BY type
COMPUTE SUM(price), SUM(advance) BY type
或者
select 字段,sum(值) from 表 group by 字段
union all
select 字段,值 from 表
SELECT type, price, advance
FROM titles
ORDER BY type
COMPUTE SUM(price), SUM(advance) BY type
或者
select 字段,sum(值) from 表 group by 字段
union all
select 字段,值 from 表
where id in (select top [规定你希望在该组中选择的条数] id from tablename tb where ta.field1=tb.field1[这里用来按field1分组] and tb.field2=[你的选取条件] and tb.field3=[你的选取条件])
(
select * from yablename
union all
select top_name,min(col1),max(col2),...sum(numField) from yablename
group by top_name
) as a
order by top_name
也可以用 :GROUP BY Item, Color WITH ROLLUP/或CUBE
SELECT CASE WHEN (GROUPING(Item) = 1) THEN 'ALL'
ELSE ISNULL(Item, 'UNKNOWN')
END AS Item,
CASE WHEN (GROUPING(Color) = 1) THEN 'ALL'
ELSE ISNULL(Color, 'UNKNOWN')
END AS Color,
SUM(Quantity) AS QtySum
FROM Inventory
GROUP BY Item, Color WITH ROLLUP