Chapter 5, Problem 5RQ

Explanation of Solution

Alias:

• It is nothing but another name given for an existing table name. During the usage of “FROM” clause, the user can give an alias name for the table names so that, the user need not to mention the table name each time rather, he/ she can use the alias name...

Explanation of Solution

Specifying alias in SQL:

In SQL, the format...

Explanation of Solution

Using alias name:

Example:

 SELECT emp_id, name, age, salary FROM EMPLOYEE E, SALARY S WHERE E.emp_id = S.emp_id;

In the above example the alia...