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

how to find the second highest salary from emp table?

Question Posted / abhay

Answer Posted / abhay

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you explain an index?

1222

What is schema in sql example?

1088

Can we use join in subquery?

1022

Can sql developer connect to db2?

985

What is the usage of distinct keyword?

1018

What is percent sign in sql?

1213

Differentiate between % rowtype and type record.

1195

How would you reference column values before and after you have inserted and deleted triggers?

1017

How can I delete duplicate rows?

964

What are the datatypes available in pl/sql ?

1043

how can we destroy the session, how can we unset the variable of a session? : Sql dba

933

How to change sql*plus system settings?

995

How to avoid using cursors?

1039

How many parts of a pl sql block are optional?

1032

How do you update sql?

913