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

Briefly explain what is literal? Give an example where it can be used?

1050

Is rowid unique in oracle?

1007

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

2197

What are the various types of snapshots ?

1033

How to initialize variables with default values?

1251

How to run create database statement again?

1164

Explain a data segment?

1076

What does sharding mean?

1011

How many types of segments in Oracle?

1078

What happens if recursive calls get out of control?

1086

What is varray?

1146

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1936

how the indexes are stored in the Oracle Database?

2277

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2312

How to load data through external tables?

1144