When you want the column name of the table to appear differently in your SQL query, just to make sure that you too can do some magic, you can use aliases. Though aliases can also be created for various database objects like tables, views, stored procedures and macros, it is the column aliases that are more frequently used. Aliases are also referred as correlation name. Except for having a better readability, column aliases can also be used anywhere in the SQL statement. It becomes handy especially if you are using a derived column. Let’s discuss what all you need to create an alias. First code example:

SELECT emp_no AS “Employee No”,
 dept_no AS “Department No”,
 salary “Employee Salary”,
 (salary* 12/100) “Salary Bonus”
FROM emp
WHERE “Department No”= 114
GROUP BY   1,2,3,4
ORDER BY “Salary Bonus”

Result:- 

Employee No Department No Employee Salary Salary Bonus
1,100 114 46,000 5,520
5,000 114 65,000 7,800
7,000 114 62,000 7,440

In the above code, you can see that the columns emp_no, dept_no, salary and the derived column (salary* 12/100) are all aliased. Also note that the alias “Department No” and “Salary Bonus” as used within the SQL query and the query returns the shown result without any hiccups. So what are the secrets? Aliases should be from 1 to 30 characters long with the following guidelines: 

  • Uppercase or lowercase letters (A to Z and a to z).
  • Digits (0 through 9).
  • The special characters DOLLAR SIGN ($), NUMBER SIGN (#), and UNDER SCORE ( _ ).
  • Must NOT begin with a digit.
  • Must NOT begin with an UNDER SCORE.
  • NO keywords can be used as aliases.
  • Alias Names can not be duplicated in the same SQL query.
  • Usage of the word AS is optional.
  • If there is a space used, make sure it is enclosed with only double quotes.

Our Random Articles

More Links