Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 44631 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 sql injection owasp?
What is the difference between nvl function, ifnull function, and isnull function?
define sql delete statement ? : Sql dba
Mention what does plv msg allows you to do?
Can we insert delete data in view?
what is rollback? : Sql dba
What is equi join in sql?
What is the use of stored procedures?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Explain the insert into statements in sql?
What normalization means?
What are the different dcl commands in sql?
Are stored procedures faster than queries?
how to include character strings in sql statements? : Sql dba
What is varchar used for?
