Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 51687 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 will you get by the cursor attribute sql%rowcount?
Can triggers stop a dml statement from executing on a table?
When sql appeared?
In what condition is it good to disable a trigger?
What is asqueryable?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Why is sql important?
what is a materialized view? : Sql dba
what is the difference between union and union all? : Sql dba
Why do we need unique key in a table?
What is foreign key in sql with example?
What is rename in sql?
What is sql entity?
Can %notfound return null after a fetch?
what are the advantages of using stored procedures? : Sql dba
