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

how to get second highest sal of emp table

Question Posted / yadunandan

Answer Posted / yadunandan

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

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between a primary key & a unique key?

1097

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2364

What is the usage of control file in oracle?

1094

What is an oracle cursor variable?

1086

how may join possible between (requisition with purchase order)

2259

How to select some columns from a table in oracle?

1101

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

1093

How to execute a stored procedure in oracle?

1098

What is the oracle implicit cursor?

1068

What are the parameters that we can pass through a stored procedure?

1070

Explain the use of indexes option in imp command.

1186

How to define an explicit cursor in oracle?

1049

what is the dual table in oracle?

1003

How to set up autotrace for a user account?

1062

Is there an oracle sql query that aggregates multiple rows into one row?

989