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;.

3rd Sep 2017, 11:11 AM
Gayan Samarakoon
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.
3rd Sep 2017, 11:37 AM
Apoorva Shenoy Nayak
Apoorva Shenoy Nayak - avatar
+ 8
Yes that's right.. Only the column names where as keyword is used!
3rd Sep 2017, 12:11 PM
Apoorva Shenoy Nayak
Apoorva Shenoy Nayak - avatar
+ 1
Hi Nayak, in the first example renaming done only for Lastname column. Right?
3rd Sep 2017, 12:10 PM
Gayan Samarakoon