Tuesday 28 May 2013

ALIAS - Column Aliases in SELECT statement

A column alias:

  • Renames a column heading.
  • Is useful with calculations.
  • AS keyword is optional between the column name and alias.
  • Requires double quotation marks if it contains spaces or special characters or is case sensitive
Using Column Aliases (with example)



No comments:

Post a Comment