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

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

619

Can we modify approve purchase order?if yes what is navigation?

1547

Explain the use of table functions.

1798

Where in the Oracle directory tree structure are audit traces placed?

2123

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

1768

How would you determine what sessions are connected and what resources they are waiting for?

1614

Explain about party and customer in ar : oracle accounts receivable

726

as a technical developer in oracle applications which type errors feced in your experience sofar

1773

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1912

What Are Cross Validation & Adi?

692

Give two methods you could use to determine what DDL changes have been made.

6023

What is an Oracle database Full Backup?

632

Difference between transaction type and transaction sources. : oracle accounts receivable

577

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1591

What is chargeback invoice? How do we create it? : oracle accounts receivable

725