Question

Consider the query: SELECT employee_id, employee_name, salary * 12 'ANNUAL SALARY FROM employees. There are few errors in this query. Identify them.
Select one:
a. Usage of single quotes in Column alias name which contains space.
b. Multiplication operator is incorrect.
c. "AS" keyword is not used for column alias name
d. All the options​

Answer 1

Consider the query: SELECT employee_id, employee_name, salary * 12 ‘ANNUAL SALARY FROM employees. There are few errors in this query. Identify them.

Select one:

a. Usage of single quotes in Column alias name which contains space.

b. Multiplication operator is incorrect.

c. “AS” keyword is not used for column alias name

d. All the options

Answer 2

C. "AS" keyword is not used for the column alias name.

"AS" Keyword :

• An SQL AS keyword is used to provide column or variable names in query an alias. In this method, the question and columns heads in the result set can be made more readable and understandable.

• Such connection name is more commonly referred to as an alias, but I'll use the formal term.

• There are additional AS keywords in Normal SQL, however, it can not be used even if it might give the impression that it is being replaced when it is not. It should actually be omitted to highlight that it is a range parameter.