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 oracle instant client?

973

How to synchronize 2 schema's objects?

2117

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2211

How to call a sub procedure?

1036

What are internal user account in oracle?

950

How to rename an index in oracle?

1064

Does facebook use oracle?

982

How to check database size in Oracle?

1120

What is an Oracle index?

1606

interview questions with answer for cts

2534

How to export data with a field delimiter?

971

What is an oracle transaction?

1055

Is oracle a language?

900

Can we convert a date to char in oracle and if so, what would be the syntax?

960

How to import one table back from a dump file?

972