Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 44619 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / vishnu
select level,max(sal) from emp
where level<=5
group by level
connect by prior sal>sal
order by level Asc;
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Explain what is table in a database?
Can we create clustered index without primary key?
Which is better trigger or stored procedure?
What is pl sql in oracle?
What is sqlcontext?
What is auto increment in sql?
How many commands are in sql?
What is the use of %rowtype?
Why do we use sql constraints?
What is pl sql quora?
What is mdb stand for?
What is clustered and nonclustered index in sql?
what is a database transaction? : Sql dba
What is the difference between in and between in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
