try this one.... select * from emp where emp_Id = (select emp

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

Question Posted / pavan

Answer Posted / pavan

try this one....

select * from emp where emp_Id = (select emp_Id from emp
order by sal)
and count(*) < 6;

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is performance tuning db2?

1112

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1223

Define data page.

1133

What is a bind in db2?

1108

can all users have the privilage to use the sql statement select * (dml)?

1224

What is the physical storage length of timestamp data type?

1151

What are the various isolation levels possible?

1181

How would the varchar column remarks defined?

1135

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1133

What is the difference between bind and rebind in db2?

1513

How to check last update on table in db2?

1101

What is difference between rollback and commit?

1206

What is the reason behind not using select * in embedded sql programs?

1174

What does runstats do in db2?

1189

List out the buffer pools in db2

1131