Question: 7 . 1 . A common use for aliases is to rename table column fields in retrieved results ( perhaps to match specific reporting or
A common use for aliases is to rename table column fields in retrieved results perhaps to match specific reporting or client needs Write a SQL statement that retrieves AddressLine City, and PostalCode from Person.Address, renaming AddressLine to Address and PostalCode to ZipCode. Sort the results alphabetically AZ by City.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
