-- 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 define an anonymous procedure without variables?

553

What is blob data type in oracle?

561

How do I limit the number of rows returned by an oracle query after ordering?

640

What is a database table in oracle?

572

What are joins, explain all types of joins?

1724

Is rowid unique in oracle?

530

What is the difference between alert log file and tarce file ?

1634

Respected sir, Please send me technical questions related to oracle apps..

1381

How many file formats are supported to export data?

659

How to use subqueries with the in operator using oracle?

614

What is an Oracle index?

1179

How to execute a stored procedure in oracle?

618

How to generate query output in html format?

570

if you ctreate table identity

1847

How to create a table in a specific tablespace?

543