--写一个查询显示订单ID,订单详情ID和那些订单总值大于订单ID43662的总值的最大值的订单总值。
--Sales.SalesOrderDetail 数据库
-AdventureWorks
-表
-Sales.SalesOrderDetail
-列
SalesOrderID
SalesOrderDetailID
CarrierTrackingNumber
OrderQty
ProductID
SpecialOfferID
UnitPrice
UnitPriceDiscount
LineTotal
rowguid
ModifiedDate
--Sales.SalesOrderDetail 数据库
-AdventureWorks
-表
-Sales.SalesOrderDetail
-列
SalesOrderID
SalesOrderDetailID
CarrierTrackingNumber
OrderQty
ProductID
SpecialOfferID
UnitPrice
UnitPriceDiscount
LineTotal
rowguid
ModifiedDate
from sales.salesordertetail
group by salesorderid,salesorderdetailid
from sales.salesordertetail
group by salesorderid,salesorderdetailid
from(
select salesorderid,salesorderdetailid,sum(OrderQty * (1-UnitPriceDiscount ) *UnitPrice ) as s
from sales.salesordertetail
group by salesorderid,salesorderdetailid)a
where s > (select sum(OrderQty * (1-UnitPriceDiscount ) *UnitPrice ) from sales.salesordertetail where salesorderid = '')
from(
select salesorderid,salesorderdetailid,sum(OrderQty * (1-UnitPriceDiscount ) *UnitPrice ) as s
from sales.salesordertetail
group by salesorderid,salesorderdetailid)a
where s > (select sum(OrderQty * (1-UnitPriceDiscount ) *UnitPrice ) from sales.salesordertetail where salesorderid = 'ID43662')