⟩ What does the following query do?
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.
Question and Answer:
Home SQL
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Tell us what are the different types of database compression introduced in SQL Server 2008?
Tell us what is a correlated sub-query?
Please explain what is meant by Active – Passive and Active – Active clustering setup?
Tell us what types of databases do you work with?
Please explain what is a Database Management System?
Do you know what is SQL Server Browser?
Tell us what Is The Difference Between Lock, Block And Deadlock?
Tell us what is the difference between Clustered and Non-Clustered Index?
Tell me when setting Replication, can you have Distributor on SQL Server 2005, Publisher of SQL Server 2008?
Explain me what is DBCC?
