Wednesday, 11 September 2013

7. Display the name, country region code, and sales year to date for the territory with Territory ID as 1. (Use the AdventureWorks database)

select * from Sales.SalesTerritory
select Name,CountryRegionCode,SalesYTD from Sales.SalesTerritory
where TerritoryID=1

No comments:

Post a Comment