select max(sal) from emp where sal not in ( select max(sal) from emp)

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

Question Posted / mehul

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

Answer Posted / mehul

select max(sal) from emp where sal not in ( select max(sal)
from emp)

Is This Answer Correct ?

29 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Give syntax for SQL and ORACLE joins.

1145

How does Oracle guarantee data integrity of data changes?

2457

defination of bitmap index

2178

Explain oracle left join with an example?

1063

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422

How to rebuild an index in oracle?

1069

How to build data dictionary view an new database?

1052

How many types of synonyms in Oracle?

1176

WHAT IS ecc 6.0

2203

How to drop a stored function?

1183

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1162

How to return top 5 rows in oracle?

1112

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2386

What is ordinary table in oracle?

1239

How to pass a parameter to a cursor in oracle?

1229