Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47437 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 rownum and rowid?
What are sql procedures?
What are the types of sql commands?
How do I add a database to sql?
What is use of package in pl sql?
How to avoid using cursors?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is optimistic concurrency control? : Transact sql
What is forward declaration in pl sql?
What are the uses of merge?
How show all rows in sql?
Why truncate is used in sql?
What does := mean in pl sql?
What are the different type of joins in sql?
What is cte sql?
