SQL (Structured Query Language) Question:
What does the following query do?
Answer:
SELECT SAL + NVL(COMM,0) FROM EMP;?
This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary.
This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary.
| Previous Question | Next Question |
| State true or false. EXISTS, SOME, ANY are operators in SQL? | Which command executes the contents of a specified file? |