-- that's it select * from (select max(salary) from salary) wher

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

Question Posted / braulio

Answer Posted / braulio

-- that's it

select * from
(select max(salary) from salary)
where rownum = 2

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a view and how is it different from a table?

973

Is postgres faster than oracle?

971

What is instant client oracle?

973

how may join possible between (requisition with purchase order)

2170

How to apply filtering criteria at group level in oracle?

987

What is oracle sid?

891

Explain how you would restore a database using RMAN to Point in Time?

2097

What do you understand by a database object? Can you list a few of them?

971

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1291

How to write a query with a right outer join in oracle?

1113

Can we use bind variables in oracle stored procedure?

899

Is oracle an operator?

885

How do I know if oracle is installed on windows?

881

What is Reduced List of Values?

2104

How to create a new table in oracle?

1067