-- 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

Explain a synonym?

1032

What is a partition in oracle?

1122

Is rowid unique in oracle?

999

How to drop a stored procedure in oracle?

1051

In oracle there is column command, how will you explain that?

1057

What is the sid in oracle?

967

How to store pictures on to the database?

976

Explain rename?

983

Explain a data segment?

1071

What is a trigger and what are its types in oracle?

1073

What is system global area (sga) in oracle?

992

What is the usage of control file in oracle?

1090

What is query image?

982

How does one get the view definition of fixed views/tables?

1021

20. Using a set operator, display the client number of all clients who have never placed an order.

2187