SQL 关于sum的问题

 查出表中价格最大的前三项，并且显示其详细信息，其余相的价格进行汇总。

declare @count intselect @count=count(*) from dbo.Ordersselect top 3 OrderID,Freight,其它总汇 from Orders,(select sum(Freight) as 其它总汇 from (select top (@count-3) OrderID,Freight from Orders order by Freight asc ) as temptable) as sumother order by Freight desc

实现效果：

declare @count int, @departsum floatselect @count=count(*) from dbo.Ordersselect @departsum=sum(Freight) from (select top (@count-3) OrderID,Freight from Orders order by Freight asc) as tablepartif object_id('tempdb..#tabletmep') is not nulldrop table #tabletmepselect top 3 OrderID,Freight into #tabletmep from dbo.Orders order by Freight descinsert #tabletmep values(@departsum)select * from #tabletmep order by freight desc

 实现效果：