SELECT min(gross) FROM(SELECT distinct(gross) FROM srbs_staff_pay

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

Question Posted / asdasd

Answer Posted / asdasd

SELECT min(gross) FROM(SELECT distinct(gross) FROM
srbs_staff_pay_dtls ORDER
BY gross DESC) WHERE ROWNUM<=4;

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is save point in oracle database?

1252

How to create lov dynamically at runtime & attach to text field?

1110

What is the purpose of tables, private synonyms and public synonyms in Oracle?

993

What is program global area (pga) in oracle?

971

How to count duplicated values in a column in oracle?

993

Explain temporal data types in oracle

1047

How to convert raw data type into text in oracle? Explain

955

how to handle exceptions in post production

1367

what is Single Byte Overhead...?

2506

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2250

How to use "in out" parameter properly?

1003

How would you change old and new values in an insert, delete and update triggers?

959

What is clustered table in Oracle?

1118

How to execute a stored procedure in oracle?

1036

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2338