SELECT Z2.SAL FROM EMP Z1,EMP Z2 WHERE Z2.SAL <=Z1.SAL GROUP BY Z2.S

write a query to find the third maximum salary of a
employee.(table:employ col name:salary)

Question Posted / jithendranath.g

Answer Posted / jithendranath.g

SELECT Z2.SAL FROM EMP Z1,EMP Z2
WHERE
Z2.SAL <=Z1.SAL
GROUP BY Z2.SAL
HAVING COUNT(Z2.SAL)=3

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is auto invoicing? : oracle accounts receivable

1084

difference of using cursor for loop and open,fetch,close.which one is better

1732

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1096

Explain prerequisites and post activities of oracle database installation

2069

What is an Oracle database Partial Backup?

1107

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2058

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2874

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3480

What is the difference between conversions and interfaces? : oracle accounts receivable

1119

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2158

Explain the process of recievables in oracle financials. : oracle accounts receivable

1100

default triggers available for reports

2153

3. Steps in UAT?

2364

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4387

Differentiate between transaction type and transaction source? : oracle accounts receivable

1063