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

How to define an explicit cursor in oracle?

1002

What is define in oracle?

1034

What is a proxy class?

989

How do I know if oracle client is installed on windows?

980

What is query image?

951

How to get a create statement for an existing table?

930

Explain parameter file in oracle.

987

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5371

What is the dynamic sql in oracle?

1033

Why do we need integrity constraints in a database?

995

What happens if the imported table already exists?

1000

How to initialize variables with default values?

1194

What do you mean by merge in oracle?

964

Which is faster join or subquery in oracle?

955

Explain cascading triggers.

1032