select e.sal from emp e where &2>(select max(count{a.sal}) from emp

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Question Posted / martin

Answer Posted / martin

select e.sal from emp e where &2>(select max(count{a.sal})
from emp a where a.sal > e.sal order by desc
)

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the difference between count (*), count (expression), count (distinct expression)?

1006

how do u setup a replication site?

1989

Please explain compound trigger in oracle?

1057

What is instant client oracle?

1021

candidate key is subset of super key but not vice-verse explain

2068

What is partitioned table in Oracle?

1189

What is the data pump import utility?

1035

What is the max number of columns in an oracle table?

1001

what is difference between sql plus and sql*plus? (not sql and sql plus).

3902

How would you go about verifying the network name that the local_listener is currently using?

2049

How to install oracle odbc drivers?

1093

what are actual and formal parameters?

1104

What is oracle update statement with inner join ?

1060

Give the various rollback segment states.

1052

How to insert multiple rows with one insert statement in oracle?

1087