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