Javatpoint Logo
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-2001AjeetMobile2
13-12-2001MayankLaptop20
26-12-2004BalaswamyWater cannon35

After applying this SQL AS example syntax

Result will be shown as this table:

DateClientProductQuantity
11-09-2001AjeetMobile2
13-12-2001MayankLaptop20
26-12-2004BalaswamyWater cannon35

Note: SQL AS is same as SQL ALIAS.

Next TopicSQL Select In




Please Share

facebook twitter google plus pinterest tumbler

Latest 4 Tutorials