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 the responsibility of the construction superintendent

1660

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

624

What is the max length of sqlca?

760

Is schema the same as database?

627

Define db2.

670

What is ibm db2 database?

530

Define data page.

628

Can you tell me how can you find out the # of rows updated after an update statement?

608

What is check constraint. Explain with example.

642

What is runstats utility in db2?

569

What are the uses of db2 optimizer?

815

What is dclgen (declaration generator)?

601

What is consistency token in db2?

638

What does sqlcabc has?

627

What is db2 purescale?

543