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

find out the second highest salary?

Question Posted / souri sengupta

Answer Posted / souri sengupta

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

This worked :)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does oracle handle read consistency?

1052

What is oracle analytical function?

1032

What is merge in oracle?

997

What is MTTR advisor in Oracle?

1035

What is oracle and what are its different editions?

1008

material view and view disadvantages?

1020

What is an oracle database table?

962

What are the uses of synonyms?

1085

How to divide query output into groups in oracle?

944

Calculate difference between 2 date / times in oracle sql?

987

What is dual table oracle?

927

What is the difference between pre-select and pre-query?

1125

In oracle there is column command, how will you explain that?

969

What language does oracle use?

1049

Is java required for oracle client?

928