SELECT min(sal) FROM(SELECT DISTINCT(sal) FROM emp ORDER BY sal DESC) WHE

Query to get max and second max in oracle in one query ?

Question Posted / amit golia

Answer Posted / amit golia

SELECT min(sal) FROM(SELECT DISTINCT(sal) FROM emp ORDER
BY sal DESC) WHERE ROWNUM<=2;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain a private synonyms?

983

What is the difference between post-database commit and post-form commit?

1108

What happens to the current transaction if the session is killed?

927

What is ceil and floor in oracle?

1011

Design database draw er diagram for a certain scenario ?

4529

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2309

What is oracle database 10g express edition?

1075

Difference between pre-select and pre-query

1031

Explain oracle instance.

1107

What are the execution control statements?

1018

What is the difference between PFILE and SPFILE in Oracle?

996

Explain an index?

1095

How does the on-delete-cascade statement work?

1061

What are the ways tablespaces can be managed and how do they differ?

2274

does the query needs a hint to access a materialized view?

1817