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

How to use "out" parameter properly?

1076

What is the recommended interval at which to run statspack snapshots, and why?

2910

How to turn on or off recycle bin for the session?

1100

How to see the table columns used in an index?

1013

What happens if the imported table already exists?

1026

How to use "while" statements in oracle?

1312

How to build data dictionary view an new database?

998

What is execute immediate in oracle?

1009

How do I connect to oracle database?

1103

What is the difference between 10g OEM and 11g OEM?

961

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2818

what is Single Byte Overhead...?

2548

How to fetch the row which has the max value for a column?

994

How do I recompile a procedure in oracle?

953

What are the numeric comparison operations?

1102