tonyedented

Alias in SQL is basically a temporary name that is given to a table or a column while writing a query. This is usually done when the column or the table names are long, so in order to render more readability, alias is given. The alias in SQL is a temporary change and only exists till the duration of that query. For column alias SELECT column_name AS alias_name FROM table_name; For table alias SELECT column_1,column_2... FROM table_name AS alias_name; Example Query SELECT M.Office_id,O.Target_Area,M.Manager_name FROM India_Offices AS O,Managers AS M WHERE O.Office_id_India=M.Office_id; To learn more refer to this article: https://www.scaler.com/topics/alias-in-sql/