SQL - As
SQL AS temporarily assigns a table column a new name. This grants the SQL developer the ability to make adjustments to the presentation of query results and allow the developer to label results more accurately without permanently renaming table columns.
SQL Select As Code:
SELECT day_of_order AS "Date",
customer As "Client",
SQL Orders Table Results:
SQL AS allows us to use any name at the presentation level and helps the developer better describe a column in the result set.
SQL Select Arithmetic Query:
SELECT (5 + 12) AS "5 plus 12 is"
SQL Arithmetic Results:
Found Something Wrong in this Lesson?
Report a Bug or Comment on This Lesson - Your input is what keeps Tizag improving with time!