Javatpoint Logo

91-9990449935

 0120-4256464

Javatpoint Logo

SQL SELECT AS

SQL 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:

Let us take a table named orders, it contains:

Day_of_orderCustomerProductQuantity
11-09-2001Osama bin qasimairplane2
13-12-2001Mukhtar mahmoodRDX20
26-12-2004BalaswamyWater cannon35

After applying this SQL AS example syntax

Result will be shown as this table:

DateClientProductQuantity
11-09-2001Osama bin qasimairplane2
13-12-2001Mukhtar mahmoodRDX20
26-12-2004BalaswamyWater cannon35

Note: SQL AS is same as SQL ALIAS

Next TopicSQL Select In




Latest 4 Tutorials on JavaTpoint