Wednesday, 11 September 2013

3. Display the customer ID and the account number of all the customers who live in the TerritoryID 4. (Use the AdventureWorks database)

select * from Sales.Customer
select CustomerID,AccountNumber from Sales.Customer
where TerritoryID=4

No comments:

Post a Comment