-- 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 regular expression in pattern match conditions in oracle?

1075

Explain compound trigger in oracle?

1089

How to commit the current transaction in oracle?

1180

How to drop an index in oracle?

1120

How to start an oracle instance?

1073

how to make an oracle object

2395

how to do daily transactions with out sql* loader control file regesterd in apps?

1730

How to use "out" parameter properly?

1124

How to connect the oracle server as sysdba?

1131

How to create a stored function in oracle?

1157

How to use select statement to count the number of rows in oracle?

1092

Where do we use decode and case statements?

1061

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2178

How many types of tables are there in oracle?

1111

How to add a new column to an existing table in oracle?

1187