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 do you mean by cursor?

946

Before you give the explain statement, what are the prerogatives?

973

What is a collection in db2?

988

What is syscat in db2?

953

When reorg is used?

1074

What is null indicator in db2?

1054

Give a brief description of db2 isolation levels?

1018

What is db2 command?

965

How to get the ddl of a table in db2?

1074

What is the maximum size of a char data type in db2?

966

How do I copy a table in db2?

957

Explain about rct.

1028

What is dbrm? What it contains? When it will be created?

996

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1046

What is with ur in db2?

1248