SELECT SAL FROM EMP A WHERE 5 = (SELECT COUNT(*) FROM EMP B WHERE B.SAL &

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

Question Posted / abhusha

Answer Posted / abhusha

SELECT SAL FROM EMP A
WHERE 5 = (SELECT COUNT(*) FROM EMP B
WHERE B.SAL >= A.SAL)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is package in db2 mainframe?

559

What is a buffer in memory?

600

Is db2 a database?

574

what is a corelated subquerry?

658

Is db2 a programming language?

606

How does coalesce work?

586

How can you do the explain of a dynamic sql statement?

637

What are the rules for db2 programming?

643

What happens in bind step in a db2 program?

569

What is the difference between cursor stability and repeatable read isolation levels?

685

What is a collection in db2?

584

What do you mean by rollback?

572

What is a db2 schema?

764

What is load replace in db2?

560

Is ibm db2 open source?

586