What does the following query do?

Question:What does the following query do??

Answer: </P><P>SELECT SAL + NVL(COMM,0) FROM EMP;</P><P>This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary.</P><P>

Tags:Interview Questions, Database, SQL,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Human Resource Management Software

Powerful, configurable software for human resources management that is easy to manage and remarkably cost-effective, whatever the size of your company. Now there’s a smarter, more efficient way to handle all of your people-related activities. Easy-to-use system manages the full hire-to-retire lifecycle...