SQL Tutorial : DRL / DQL - ALIASES

SQL Tutorial : DRL / DQL - ALIASES

Let's learn about next topic: ALIASES NAMES

ALIASES NAMES:

*****************

- ALTERNATIVE NAMES OR MEANINGFUL NAMES FOR COLUMNS GIVEN ON TEMPORARY BASIS

Points to note:
- SPACE OR SPECIAL CHARACTERS WE NEED TO GIVE

- ALIASES NAMES IN DOUBLE QUOTES:

SELECT EMPLOYEE_ID AS EMPID ,LAST_NAME EMP_NAME

,SALARY,(500+SALARY)*12 "ANNUAL SALARY "
FROM EMPLOYEES