获取数据集:
declare @pp int declare @pp1 int declare @pp2 int select @pp1=sum(Quantity) from [Order Details] select @pp=sum(total) from ( SELECT TOP (5) ProductID, SUM(Quantity) AS total FROM [Order Details] GROUP BY ProductID order by SUM(Quantity) desc) a select @pp2=@pp1-@pp select * from( SELECT TOP (30) ProductID, SUM(Quantity) AS total FROM [Order Details] GROUP BY ProductID order by SUM(Quantity) desc) b union select '99',(select @pp2)