select salary from (select salary from table_name order by salary desc) whe

Query to get max and second max in oracle in one query ?

Question Posted / deepa

Answer Posted / deepa

select salary from (select salary from table_name order by salary desc) where rownum<3;

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

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

1138

What is the difference between "as" and "is" in an oracle stored procedure?

1046

What is user managed backup in Oracle?

1205

What is an oracle transaction?

1228

What is define in oracle?

1110

What is transaction control statement and how many types of transaction control statement in Oracle?

1235

How to change program global area (pga) in oracle?

1147

What is archive log in Oracle?

1182

How to bring a tablespace online?

1143

How to assign data of the deleted row to variables?

1116

Explain what are synonyms used for?

1094

What is a dynamic performance view in oracle?

1058

How to connect to oracle using service name instead of sid?

1068

How to create tables for odbc connection testing?

1206

How to convert a string to a date in oracle database?

1100