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

When the like statement is used?

648

Define predicate?

651

What's The Error Code For Unique Index Voilation?

661

What parameters are used to control the free space in DB2?

651

Can we insert update delete in view?

587

What is the usage of open cursor command?

613

What is a cursor in programming?

610

What is db2 bind process?

768

Can one database have multiple instances?

589

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

663

Why select is not preferred in embedded sql programs?

723

What is a dbrm in db2?

586

How will you return the number of records in table?

525

Explain package in db2 and its advantages?

608

What are the different types of base tables?

591