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

how to find the second highest salary from emp table?

Question Posted / kameshwar shukla(a.i.e.t l.k.o

Answer Posted / kameshwar shukla(a.i.e.t l.k.o

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we insert in view in sql?

1004

Difference between truncate, delete and drop commands?

1025

What is an exception in pl/sql?

1009

How to run sql commands in sql*plus?

1082

what are all the common sql function? : Sql dba

1013

What is user in sql?

970

Explain select statements in sql?

1003

What is sql injection vulnerability?

872

How do I count rows in sql?

948

How to select 10 records from a table?

1099

What are the parts of a basic sql query?

920

How insert into statements in sql?

1011

explain the difference between delete , truncate and drop commands? : Sql dba

1020

how to drop an existing index in mysql? : Sql dba

1018

What are literals in sql server?

1075