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

Mention the various locks that are available in db2.

1041

What is blu acceleration in db2?

1072

Explain about mirror activator disk mirroring?

1012

How does db2 sample database connect?

1034

i want to maintain uniqueness on pdf without make lf??????????

2158

What is the use of with ur in db2?

1058

What is scrollable cursor in db2?

1055

How to check table size in db2 sap?

1040

Define db2.

1119

Explain the function done by data manager?

1280

How to connect to db2 database from windows command line?

1066

List out the buffer pools in db2

1075

What is a bind card?

1218

Explain the contention situations caused by locks?

1070

Mention the location where the output received from explain statement is stored.

1127