select max(sal) from employees where sal < (select max(sal) from employ

1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.

Question Posted / ramya

Answer Posted / ramya

select max(sal) from employees where
sal < (select max(sal) from employees)

Is This Answer Correct ?

21 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is oracle datasource?

993

How to define an explicit cursor in oracle?

1045

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1079

How to retrieve data from an cursor to a record?

1109

Point the difference between translate and replace?

1096

Explain oracle instance.

1185

How to convert characters to dates in oracle?

1104

What are the differences between date and timestamp in oracle?

1051

How to create a table index?

1156

What are data pump export and import modes?

1072

What happens if you lost a data file?

1037

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2401

How to get the Installed Oracle Version Information ?

1128

What is the maximum limit on the number of columns in a table?

1089

Explain the use of grant option in imp command.

1032