how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / praveen marigaddi.
select distinct sal from emp a where 5 >(select count
(distinct sal) from emp where sal>a.sal) order by a.sal desc
Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
Explain implicit cursor.
What is flashback in Oracle?
What is tns entry?
How to define default values for formal parameters?
Design database draw er diagram for a certain scenario ?
What is a sub query and what are the different types of subqueries?
How to assign query results to variables?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
what is reindexing?
Explain the difference between a procedure and a function? What do you understand by those terms?
What are the uses of Database Trigger ?
How to manage transaction isolation level?
Can you have more than one content canvas view attached with a window ?
How will you differentiate between varchar & varchar2?
Why does Oracle not permit the use of PCTUSED with indexes?