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

find out the second highest salary?

Question Posted / mallikarjun

Answer Posted / mallikarjun

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

Mallikarjun

Is This Answer Correct ?

216 Yes

86 No

Please Help Members By Posting Answers For Below Questions

How to convert numbers to characters in oracle?

992

What is oracle sid?

906

How many data types are supported?

1048

How are extents allocated to a segment?

1090

What is an oracle tablespace?

1009

Explain the use of tables option in exp command.

1076

What is the difference between formal parameters and actual parameters?

1035

What is a data lock in oracle?

1056

Can you drop an index associated with a unique or primary key constraint?

984

How do I manually create a database in oracle?

979

What is the usage of analyze command in oracle?

1053

Name the various constraints used in oracle?

987

How to define a variable to match a table column data type?

952

How to find the duplicate rows count from employees table in oracle?

1059

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2323