how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / karthik
select * from (select ename,eno,dept,sal,row_number() over
(partition by dept order by sal desc)top5 from emp) where
top5 <= 5
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is redo log?
How to find out what oracle odbc drivers are installed?
State and explain the different types of data models?
Explain the truncate in oracle?
what are bitmap indexes? How does they work?
What happens if you lost a data file?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are the most common interview questions on ETL Testing for experience?
Explain the difference between replace() and translate() functions in oracle?
How to delete all rows a table in oracle?
What are the system predefined user roles?
How to best split csv strings in oracle 9i?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is memory advisor in Oracle?
What is tns name?