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 do you mean by redo log file mirroring?

1071

Give the constructs of a package, function or a procedure.

1098

What is the difference between hot backup and cold backup in oracle?

1078

Why do we need integrity constraints in a database?

1076

Can we store pictures in the database and if so, how it can be done?

1089

Explain what are the different type of segments?

1003

How does Oracle guarantee data integrity of data changes?

2458

What is a nested table and how is it different from a normal table?

1112

What happens to the data files if a tablespace is dropped?

1107

How to convert times to characters in oracle?

1071

What are the limitations of check constraint?

1075

How to start your 10g xe server?

1089

Does facebook use oracle?

1084

How do I connect to oracle?

1080

Can we save images in a database and if yes, how?

1112