Wednesday, 11 September 2013

20. Display the order number and the total value of the order in ascending order of the total value. (Use the AdventureWorks database)

select * from Sales.SalesOrderHeader
select SalesOrderId,TotalDue from Sales.SalesOrderHeader
order by TotalDue ASC

No comments:

Post a Comment