Guys try this to get 2nd highest salary select max(salary) from employee

find out the second highest salary?

Question Posted / anil

Answer Posted / anil

Guys try this to get 2nd highest salary

select max(salary) from employee where salary not in (select
max(salary) from employee)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain about functional dependency and its relation with table design?

1017

What are the ansi data types supported in oracle?

948

How many types of cluster table in Oracle?

1034

How to rename an index?

1076

What is oracle update statement with inner join ?

1066

How to install oracle database 10g xe?

1024

What is varray?

1146

List out the difference between commit, rollback, and savepoint?

1038

what is difference between sql plus and sql*plus? (not sql and sql plus).

3905

Explain the use of Merge statement in oracle 11g

1029

What happens to indexes if you drop a table?

1171

What is oracle thin client?

1029

Can we write dml statement in function in oracle?

1088

Explain the use of indexes option in exp command.

1153

How to find out what oracle odbc drivers are installed?

1045