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