Wednesday, 11 September 2013

14. Display the orders placed on July 01, 2001 that have a total cost of more than $ 10,000 in the following format. (Use the AdventureWorks database)

select * from Sales.SalesOrderHeader
select SalesOrderID,orderdate,status,subtotal from Sales.SalesOrderHeader
where ShipDate='2001-07-01'and SubTotal>10000

No comments:

Post a Comment