select max(salary) from employee where salary<(select max(salary) from

find out the second highest salary?

Question Posted / amulya kumar panda

Answer Posted / amulya kumar panda

select max(salary) from employee where
salary<(select max(salary) from employee)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is an index associated with a constraint?

1040

What is recycle bin in Oracle?

1153

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

Explain oracle’s server parameter file.

997

What is Trigger in Oracle?

1176

How to select all columns of all rows from a table in oracle?

1055

Explain the use of rows option in exp command.

1094

What is recovery manager in Oracle?

1057

What happens to the data files if a tablespace is dropped?

1061

How to create an oracle testing table?

1072

What are the different types of failures that occur in Oracle database?

1068

Explain the different normalization forms?

1107

How to work with data objects interactively?

989

How to recover a dropped table in oracle?

1048

Explain the difference between a procedure and a function? What do you understand by those terms?

1090