By 25/02/2016 1 Comments

What Is Aliases In SQL?

  • Aliases in SQL are user defined names which are given to column or table of database for temporarily basis.

OR

  • SQL Aliases are used to rename a column or table in database (temporary).
  • SQL Aliases are very useful when database tables or its column have their long names.
  • SQL Aliases give a new name to table or its column at run-time only (not permanent).
  • SQL Aliases make a table or column more readable.

Syntax For Table’s Columns:

SELECT column_name AS alias_name
FROM table_name;

Example:

SELECT p_name AS "Product Name", price AS "Product Price"
FROM products;

Syntax For Table:

SELECT column_name(s)
FROM table_name AS alias_name;

Example:

SELECT p.p_name AS "Product Name", p.price AS "Product Price"
FROM products AS p;





Next Tutorial →



Posted in: Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .