select max(salary) from staff where salary not in(select salary from sta

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

Question Posted / rajib

Answer Posted / rajib

select max(salary) from staff where salary not in(select
salary from staff order by salary desc fetch first 4 rows
only)

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Are view updateable?

986

How do I optimize a query in db2?

1042

What is the difference between spufi and qmf?

1055

What do you mean by rollback?

937

What is a system catalog table in db2?

1108

What is declare cursor?

1046

Is schema the same as database?

1008

What is the usage of open cursor command?

1040

Explain the function of data manager.

993

What's The Error Code For Unique Index Voilation?

1155

What is dclgen in db2?

1087

what is db2 restart?

2104

What is cascading rollback?

1135

Explain the benefits you can get from mainframe connect?

913

What is db2 look?

976