Wednesday, 11 September 2013

17. Display the order ID and the tax amount for the sales orders that are less than $ 2,000. The data should be displayed in ascending order. (Use the AdventureWorks database)

select * from Sales.SalesOrderHeader
select SalesOrderID,TaxAmt from Sales.SalesOrderHeader
where TotalDue < 2000
 order by TotalDue ASC

No comments:

Post a Comment