select top 1 * from (select customerid,sum(quantity) as qty from [order details] group by customerid)t order by qty desc,customerid
select top 1 * from [order details] order by Quantity union all select top 1 * from [order details] order by Quantity desc
select customerID 最大 from [order details] where Quantity =( select max(Quantity) from [order details]) select customerID 最小 from [order details] where Quantity =( select min(Quantity) from [order details])
select top 1 * from [order details] order by Quantity union all select top 1 * from [order details] order by Quantity desc
要用一条SQL语句啊,不是两个Select
select * from [order details] where customerID in ( select top 1 CustomerId from [order details] order by Quantity union select top 1 CustomerID from [order details] order by Quantity desc )
select CustomerId from [order details] where Quantity in(select max(Quantity) from [order details] union select min(Quantity) from [order details]) go
select customerID 最大 from [order details] where Quantity =( select max(Quantity) from [order details]) union all select customerID 最小 from [order details] where Quantity =( select min(Quantity) from [order details])
from (select customerid,sum(quantity) as qty from [order details] group by customerid)t
order by qty desc,customerid
union all
select top 1 * from [order details] order by Quantity desc
select customerID 最小 from [order details] where Quantity =( select min(Quantity) from [order details])
union all
select top 1 * from [order details] order by Quantity desc
select * from [order details] where
customerID in (
select top 1 CustomerId from [order details] order by Quantity
union
select top 1 CustomerID from [order details] order by Quantity desc
)
union select min(Quantity) from [order details])
go
union all
select customerID 最小 from [order details] where Quantity =( select min(Quantity) from [order details])