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

34 Answers
65261 Views
CTS, Keane India Ltd, TCS, Wipro, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to convert characters to times in oracle?

1016

Explain the difference between replace() and translate() functions in oracle?

1027

Explain oracle instance.

1167

How index is implemented in oracle database?

999

How to sort the query output in oracle?

1023

How to retrieve data from an cursor to a record?

1096

What is primefaces used for?

1045

How to drop an existing view in oracle?

940

What are the advantages of oracle 12c?

1175

What do you know about normalization? Explain in detail?

943

What is the usage of analyze command in oracle?

1088

How to sort output in descending order in oracle?

1036

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1100

What is the difference between translate and replace?

1053

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2259