SQL Interview Questions and Answers
Question: What does the following query do? SELECT SAL + NVL(COMM,0) FROM EMP;Answer: This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary. |
Save For Revision
Bookmark this item, mark it difficult, or place it in a revision set.
Log in to save bookmarks, difficult questions, and revision sets.
Is it helpful? Yes No
Most helpful rated by users: