how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / jas
select a.sal,a.emp_no from employee a
where 5=(select distinct(count(*) from
employee b where a.sal> b.sal)
Is This Answer Correct ? | 8 Yes | 9 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
When do you get a .pll extension in oracle? Explain its importance
What are the differences between char and varchar2 in oracle?
How to use subqueries with the in operator using oracle?
How to define a sub function?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Is it possible to insert comments into sql statements return in the data model editor ?
what is Single Byte Overhead...?
How do I know if oracle is installed on windows?
How to open and close an explicit cursor in oracle?
How to add another datafile to a tablespace?
What are the different editions of oracle?
How to use "out" parameter properly?
How to rename a column in an existing table?