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

How to define and use table alias names in oracle?

933

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2118

How would you begin to troubleshoot an ORA-3113 error?

2075

Explain how are indexes update?

1060

What are temporal data types in oracle?

1116

How many categories of data types?

985

Explain an extent?

1092

What is oracle database client?

1025

Explain the use of tables option in exp command.

1108

How to put more than 1000 values into an oracle in clause?

1028

How to count groups returned with the group by clause in oracle?

1064

How to use subqueries with the in operator using oracle?

1088

Explain alias?

1122

What are the common oracle dba tasks?

1138

What is different types of joins?

1018