Walkins Openings in India & Interview Questions

Walkins in Mumbai, Bangalore, Chennai, Delhi, Gurgaon, Pune

Search our list of 4266 Walkins & Interview Questions


What does the following query do? 

Posted in SQL Interview Questions

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.

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
Post Your Answer!
Send This to a Friend

← Why does the following command give a compilation error?
What command is used to create a table by copying the structure of another table? →

If you liked this question/asnwer, make sure you
Subscribe to Walkins Openings in India & Interview Questions RSS feed!




Related Content

  • What is an ABAP/4 Query?  04.08.07

    ABAP/4 Query is a powerful tool to generate simple reports without any coding. ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the s...

  • What is a query?  28.07.07

    A query with respect to DBMS relates to user commands that are used to interact with a data base. The query language can be classified into data definition lang...

  • What do you mean by Correlated sub query?  28.07.07

    Sub queries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the sub query is written, it can be execut...

  • What is DML Compiler?  28.07.07

    It translates DML statements in a query language into low-level instruction that the query evaluation engine can understand....

  • What is the DIFFERENCE between PRE-QUERY and POST-QUERY ?  27.07.07

    PRE-QUERY  fires ONLY ONCE during EXECUTE-QUERY or COUNT-QUERY processing, just before Oracle Forms constructs and issues the SELECT statement to identify rows...

  • Subscribe

      Get Latest Walkins in your INBOX, enter your email address:


  • Walkins by Location


  • Walkins by Skills