Following two queries in the description, do they have same result? I meant As key word does it make sense?

Question

Select Firstname, Uppercase( Lastname ) as Lastname from Customers;, Select Firstname, Uppercase( Lastname ) from Customers;.

Answer 1

Both the queries are used for retrieving the same data. Just that in first case, the labels/column headers would be FirstName and LastName. As keyword is used for renaming the column header.

Answer 2

Yes that's right.. Only the column names where as keyword is used!

Answer 3

Hi Nayak, in the first example renaming done only for Lastname column. Right?