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

What is buffer pool in the db2 database?

1047

What are types of indexes?

1001

How connect db2 database to datastage?

1191

On which levels locks can be applied?

1063

What is ibm db2 database?

953

Explain various types of locks in db2?

1086

What are the various isolation levels possible?

1051

What is host variable?

1016

How do I delete a table in database?

977

What is db2 bind process?

1183

How to rename a table in DB2 ?

1033

How many types of page locks can be held in db2?

996

What are host variables in db2?

993

What kind of database is db2?

977

What is sqlca?

1001