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

how to find the second highest salary from emp table?

Question Posted / muhammed zaheer

Answer Posted / muhammed zaheer

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

Is This Answer Correct ?

86 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Can we create foreign key without primary key?

995

What is denormalization in a database?

1064

What does select * from mean in sql?

3258

How many sql commands are there?

1127

Differentiate between sga and pga.

1172

What is the least restrictive isolation level? : Transact sql

1080

What is not in sql?

956

What is pivot in sql?

920

What are the various levels of constraints?

1133

How do I write a sql query in pgadmin 4?

999

What are different types of triggers?

1119

How global cursor can be declare with dynamic trigger ?

2219

What is join view in sql?

951

Can cursors be part of a trigger body?

1648

What is difference between ms sql and mysql?

976