Sql Alias

Posted by  Manish Kumar
 731  View(s)
Rate this:
  1. Sql Alias

    Sql Alias are use to rename a table or a column name temporarily by giving another name.

    It mekes table or column name more readable.

    An alias only exists for the duration of the query.

    syntax for Alias Column
    SELECT column_name AS alias_name
    FROM table_name;
    Synatax for Alias Table
    SELECT column_name(s)
    FROM table_name AS alias_name;