alias in SQL

alias is used to provide another name to a column or table in result. generally, alias is used for clear and simple column name.

syntax :-

1. SQL alias syntax for columns -

select column_name as alias_name from table_name where predicate;

example :- select order_price as sell_price from orders;

2. SQL alias syntax for table -

select column_name from table_name as alias_name where predicate;

example :- select quantity from sells as S where S.orderID>5;