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

What is a oracle database?

1011

What is a view and how is it different from a table?

989

What is an oracle recycle bin?

951

Can we call procedure inside function in oracle?

1039

What is a user account in oracle?

1077

What is oracle database 10g express edition?

1088

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2914

How to convert characters to numbers in oracle?

1021

What is oracle used for?

989

How to retrieve data from an explicit cursor?

1020

How do we create privileges in oracle?

1005

What is the quickest way to fetch the data from a table?

1014

How to select all columns of all rows from a table in oracle?

1015

How to convert csv to table in oracle?

943

What do you mean by redo log file mirroring?

988