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

Why cursor variables are easier to use than cursors?

1022

How to select some rows from a table in oracle?

1008

Differentiate between pre-select and pre-query?

1055

What operating systems are supported by oracle database 10g xe?

985

How to connect asp pages to oracle servers?

1007

Why do we use coalesce function in oracle?

1053

What is catalog in Oracle?

1266

How do I escape a reserved word in oracle?

1132

How can we find out the current date and time in oracle?

1037

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2211

How can we delete duplicate rows in a table?

929

Explain the use of indexes option in imp command.

1088

How to calculate date and time differences in oracle?

994

Name the various constraints used in oracle?

971

What is oracle server autotrace in oracle?

1091