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

10 Answers
17783 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is db2 bind process?

1244

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2331

What does db2 mean?

1021

What is sqlca’s maximum length?

1195

What is db2 instance?

1110

What is bind plan?

1054

How to get the ddl of a table in db2?

1131

Explain what are the various isolation levels possible?

1044

What is a storage group (stogroup)?

1248

Which are the db2 tools to protect integrity of the database?

1124

What is buffer pool and list some of them?

1036

Define declaration generator (dclgen).

1122

What types of tables are there in the db2 database?

1061

What is multi row fetch in db2?

1052