Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 47563 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / ajay dond
select salary from (select distinct salary from employees
order by salary desc)
where rownum<6
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we use joins?
What is before and after trigger?
What are the limitations of sql express?
How do you optimize a stored procedure query?
What is range partitioning?
What is spool?
What is a primary key? Explain
Can I learn sql in a week?
What is data manipulation language?
What is the usage of nvl function?
What is pl sql in oracle?
Which is better join or inner query?
Explain the types of joins in sql?
What is mutating error?
What is the difference between local and global temporary table?
