0
Following two queries in the description, do they have same result? I meant As key word does it make sense?
Select Firstname, Uppercase( Lastname ) as Lastname from Customers;, Select Firstname, Uppercase( Lastname ) from Customers;.
3 Réponses
+ 8
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.
+ 8
Yes that's right.. Only the column names where as keyword is used!
+ 1
Hi Nayak, in the first example renaming done only for Lastname column. Right?