how to find the fifth highest salary?
Answer Posted / saraswathi muthuraman
Try this :
SQL> select * from (select emp_no,dep_no,sal,rank() over
(order by sal desc) as rank_list from emp_test group by
emp_no,dep_no,sal) where rank_list =5;
1005 11 50 5
This seems to be a correct answer if few employ having same sal
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you communicate with an RDBMS?
What is durability in DBMS?
What is a query?
What is RDBMS KERNEL?
What is the job of the information stored in data-dictionary?
What is join dependency and inclusion dependency?
What is DML (Data Manipulation Language)?
What is Data Storage - Definition Language?
What is the difference between cube operator and roll up operator? : sql server architect
State the different extensions for stored procedures?
What is a Phantom Deadlock?
What is n tier architecture with example?
What is difference between two tier and three tier?
What is Data Model?
What is indexing and what are the different kinds of indexing?