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

What is a package in oracle?

1161

What are a cluster and non-cluster index?

1064

How to get the Installed Oracle Version Information ?

1189

What is a server parameter file in oracle?

1097

Can we protect our pl/sql source code?

1083

How do I connect to oracle?

1080

defination of bitmap index

2178

What is an oracle user role?

1040

What is data block in Oracle?

1149

How different is ms access and oracle?

1089

Explain implicit cursor.

1075

List out the types of joins.

1238

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

3019

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2319

What are the ways tablespaces can be managed and how do they differ?

2446