select sal from employee where sal >= (select max(sal) from employee wh

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

Question Posted / naveen

Answer Posted / naveen

select sal from employee where sal >= (select max(sal) from
employee where sal not in (select max(sal) from employee))

Is This Answer Correct ?

7 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is translate in oracle?

1090

How many types of tables supported by oracle?

1069

How translate command is different from replace?

1074

What is blob data type in oracle?

1113

State all possible different index configurations a table can possibly have?

992

What is integrity and what is constraint??Explain with example

2275

What is dynamic proxy?

999

Can we convert a date to char in oracle and if so, what would be the syntax?

1004

What is the difference between hot backup and cold backup in oracle?

1008

Explain the use of show option in imp command.

1090

What do you understand by a database object? Can you list a few of them?

1014

What is the quickest way to export a table to a flat file?

960

How to add a new column to an existing table in oracle?

1131

What privilege is needed for a user to connect to oracle server?

987

Is oracle an operator?

922