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 I quit sql?

894

What programs use sql?

940

What is data modelling in sql?

959

What are the different sql languages?

984

Can a commit statement be executed as part of a trigger?

995

Write the alter statement to enable all the triggers on the t.students table.

1066

What is a sql schema used for?

1026

Where is sql database stored?

918

What are the types of records?

951

What are the main features of cursor?

1038

What is cross join sql?

863

Is coalesce faster than isnull?

906

What is mutating error?

906

Mention what is the plv (pl/vision) package offers?

1055

Is the primary key an index?

981