SELECT sal FROM(SELECT DISTINCT(sal) FROM employees ORDER BY sal DESC) WH

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

Question Posted / samir kumar sahoo

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

Answer Posted / samir kumar sahoo

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

Is This Answer Correct ?

23 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1891

How to import one table back from a dump file?

1032

How can we find out the current date and time in oracle?

1095

What are the restrictions in a oracle read only transaction?

1040

What is logical backup in oracle?

1025

what is the dual table in oracle?

1003

List the various oracle database objects?

1062

if you ctreate table identity

2380

What are internal user account in oracle?

1018

What is recycle bin in Oracle?

1160

Whether any commands are used for months calculation? If so, what are they?

1099

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1054

Can we commit inside a function in oracle?

972

What is the difference between pre-select and pre-query?

1226

How do I find my oracle client driver version?

1048