6.Display the customer ID, name, and sales person ID for all the stores. According to the requirement, only first 15 letters of the customer name should be displayed. (Use the AdventureWorks database)
select customerID, Name=Left(name,15),salesPersonId from sales.store
No comments:
Post a Comment