Sunday 6 October 2013

05. Write a query to display the order number, territory name, order date, and the quarter in which each order was placed in the following format.






select salesOrderID,'territory name'= name
OrderDate, Quarter = detepart (qq,OrderDate)
from sales.salesOrderHeader s
join sales.salesTerritory t
on s.TerritoryID =t.TeriitoryID

No comments:

Post a Comment