Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 44438 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is the use of index in sql?
What is difference between pls_integer and integer?
What are triggers in sql?
explain commit and rollback in mysql : sql dba
What is a column in a table?
What are sql functions? Describe in brief different types of sql functions?
explain the difference between myisam static and myisam dynamic. : Sql dba
how to escape special characters in sql statements? : Sql dba
How can check sql version from command line?
What are tables and fields in the database?
What is partition by in sql?
What does where 1 1 mean in sql?
How do I partition a table in sql?
Does execute immediate commit?
Why select is used in sql?
