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

i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table

Question Posted / mohan

Answer Posted / mohan

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What suggestions do you have to reduce the network traffic?

1020

How to use subqueries with the in operator using oracle?

1138

Explain oracle insert into command?

1158

What are the components of logical database structure in oracle database?

1137

Explain compound trigger in oracle?

1088

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2091

How to grant create session privilege to a user in oracle?

1052

What is oracle open database communication (odbc)?

1083

How to list all indexes in your schema?

1141

How to start instance with a minimal initialization parameter file?

1085

What is an Oracle Instance?

1163

Please explain oracle left join with an example?

1095

Can a formula column referred to columns in higher group ?

2553

What is enter substitution variable in oracle?

1095

What is oracle data type?

1008