Whether both gives same result or different ??

Question

SELECT FirstName, UPPER(LastName) AS LastName
FROM employees;

As

SELECT FirstName, UPPER(LastName)
FROM employees;

Answer 1

You use "AS" just to change the column name at the time of display.

So you should get pretty much the same result for both queries.

Answer 2

query will select same data .
but resulting column names will be different.

for example,
first query will have resulting column name `LastName`(you renamed it using AS)

where as second query will have resulting column name UPPER(LastName)

actual column names may vary slightly, it's just an example.

You can use AS keyword when your resulting column names are too long. It just renames resulting column doesn't change it's content.

You can search for AS keyword on net.

Answer 3

lucky Read what 🇮🇳Omkar🕉 has mentioned, the answer is there.

Answer 4

Then at the time of display for the second code whether it displays or not ? If displays what's the column name ?

Answer 5

Ok bruh !! TQ