select * from emp where sal = (select max(sal) from emp where sal<>(s

how to find out second largest value in the table

Question Posted / anandh

Answer Posted / anandh

select * from emp where sal = (select max(sal) from emp where sal<>(select max(sal) from emp));

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the use of rows option in exp command.

1094

What are the extensions used by oracle reports?

1039

How do I spool to a csv formatted file using sqlplus?

1038

What is execute immediate in oracle?

1023

In oracle there is column command, how will you explain that?

1057

What are the restrictions on external table columns?

1054

What are joins, explain all types of joins?

2299

What is a relational database management system?

1120

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

How to commit the current transaction in oracle?

1123

State some uses of redo log files?

1012

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2146

How does one get the view definition of fixed views/tables?

1023

Difference between hot backup vs. Cold backup?

998

What is a proxy class?

1059