SELECT last_name, salary FROM (select last

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / nitin umale

Answer Posted / nitin umale

SELECT last_name, salary
FROM (select last_name, NVL(salary,0) salary
FROM employees
ORDER BY NVL(salary,0) DESC )
WHERE rownum<6;

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do we use distinct statement? What is its use?

1075

What are the various restrictions imposed on view in terms of dml?

1017

Can we insert data into view?

950

Explain the uses of control file.

1100

Why indexing is needed?

1044

What is a scalar value in sql?

1122

How to add, remove, modify users using sql?

1089

What is the difference between null value, zero, and blank space?

1255

what's the difference between a primary key and a unique key? : Sql dba

1110

How to create an array in pl/sql?

1122

What is difference between rank () row_number () and dense_rank () in sql?

1160

Can we create table in function?

1021

What is audit logout in sql profiler?

1073

What are the different ways to optimize a sql query?

990

How to run pl sql program in mysql?

1071