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 a connect identifier?

1039

What is oracle join syntax?

1003

What is oracle data type?

964

How to convert characters to times in oracle?

1023

How to insert a record into a table?

1070

How do I learn what codesets are available in oracle?

1038

What is an oracle function?

1165

Explain the different normalization forms?

1103

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

Please explain oracle data types with examples?

1073

Why does oracle 9i treat an empty string as null?

1056

what is a Nested Loop join?

2117

What is the data type of dual table?

995

How to commit the current transaction in oracle?

1120

What are the different types of partitions in oracle?

979