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

various types of hints and their usage

2669

What is raw datatype?

1115

What are operators in oracle?

1041

How to create a new table in oracle?

1134

What is the difference between sharding and replication?

1019

How to enter a new row into a table interactively?

993

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

1053

Explain compound trigger in oracle?

1019

Is oracle a programming language?

969

Difference between cartesian join and cross join?

1010

What is proxy method?

959

How to drop a tablespace?

1027

What is a table index?

1071

How to convert character types to numeric types?

1096

how may join possible between (requisition with purchase order)

2232