Wednesday, 11 September 2013

16. Display a report of all the orders in the following format. (Use the AdventureWorks database)

select * from Sales.SalesOrderDetail
select 'Order ID'= salesOrderID,'Order Quantity'=OrderQty,'unit Price'=unitPrice,'Total cost'= OrderQty*UnitPrice from Sales.SalesOrderDetail

No comments:

Post a Comment