Try this : SQL> select * from (select emp_no,dep

how to find the fifth highest salary?

Question Posted / saraswathi muthuraman

8 Answers
12434 Views
IBM, Infosys, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are pages and extents? : sql server architect

778

What is the Disadvantage in File Processing System?

804

What is tier in database?

756

How can we call stored procedures inside store procedures?

768

What is database architecture? : sql server architect

816

What is Relational Calculus?

803

What is end user data?

725

What do you mean by flat file database?

856

Not only RDBMS takes care of locating data it also

730

What is DDL (Data Definition Language)?

826

What is a query?

814

What is an Extension of entity type?

811

What are the unary operations in Relational Algebra?

776

What is a view? How it is related to data independence?

834

What is difference between two tier and three tier?

802