Sunday 6 October 2013

01. Write a query to display the sales person ID, territory ID, and territory name of all the sales persons in the following format.








select 'person Id'=salesPersonID,
'territory ID'=s.TerritoryID,Name
from sales.salesperson s join
sales.salesterritory t
on s.territoryID = t.territoryID

No comments:

Post a Comment