select * from emp A where 4 = (select count(*) from emp B

There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........

Question Posted / kasyapa

Answer Posted / kasyapa

select * from emp A where 4 = (select count(*) from emp B
where A.sal<B.sal)

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

i want to maintain uniqueness on pdf without make lf??????????

1635

If I have a view which is a join of two or more tables, can this view be updateable?

694

Why select is not preferred in embedded sql programs?

715

Explain about mirror activator disk mirroring?

560

What is a dbrm in db2?

576

What are the contents of a dclmgen?

628

How to test SQL -911 error while developing COB-DB2 program

6716

What is data manager?

610

How would you find out the total number of rows in a db2 table?

579

Which isolation level provides highest data integrity?

599

What is the picture clause of null indicator variable?

692

What is nvl in db2?

628

What is the maximum size of a char data type in db2?

588

What is query_cache_limit?

545

What is a db2 collection?

605