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_order Customer Product Quantity
11-09-2001 Ajeet Mobile 2
13-12-2001 Mayank Laptop 20
26-12-2004 Balaswamy Water cannon 35

After applying this SQL AS example syntax

Result will be shown as this table:

Date Client Product Quantity
11-09-2001 Ajeet Mobile 2
13-12-2001 Mayank Laptop 20
26-12-2004 Balaswamy Water cannon 35

Note: SQL AS is same as SQL ALIAS.

Next TopicSQL Select In




Contact US

Email:[email protected]

SQL AS
10/30