select ename,salary from (select distinct(salary) from employee order by

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

Question Posted / haddy

Answer Posted / haddy

select ename,salary from (select distinct(salary) from
employee order by salary desc) where rownum<=2

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the use of inctype option in exp command.

978

what are the advantages of running a database in archive log mode?

2144

How to apply filtering criteria at group level in oracle?

987

What is define in oracle?

999

Explain the difference between replace() and translate() functions in oracle?

976

What are the different types of record groups in oracle? Explain each of them

972

How to get the Installed Oracle Version Information ?

1074

Explain the use of ignore option in imp command.

977

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2247

Can we use bind variables in oracle stored procedure?

899

What do you know about normalization? Explain in detail?

881

What privilege is needed for a user to query tables in another schema?

922

How to create tables for odbc connection testing?

1011

How to start a new transaction in oracle?

1016

How can we find out the current date and time in oracle?

1037