SQL SELECT AS is used to assign temporarily a new name to a table column.
It makes easy presentation of query results and allows the developer to label results more accurately without permanently renaming table columns.
Let\’s see the example of select as:
SELECT day_of_order AS \"Date\" Customer As \"Client\" , Product,Quantity FROM orders;