🐘Column Alias

Describe about Alias command

Alias is a command that you can assign temporary name to the column Illustrates the syntax of using a column alias:

Select first_name, last_name as surname from customer

The AS keyword is optional so you can omit it like this

Select first_name, last_name surname from customer

In case that you would like the temporary name to have the space you can use double quoete

example

Select first_name || ' ' || last_name surname as "full name" from customer