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

how to find the second highest salary from emp table?

Question Posted / em rao

Answer Posted / em rao

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

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I view a table in sql?

947

What is a crud api?

900

Can we use delete in merge statement?

1000

What can I use instead of union in sql?

903

What is a pragma statement?

1200

What is the use of index in hive?

958

what are the authentication modes in sql server? How can it be changed? : Sql dba

1320

What is the use of <> sql?

931

What is the location of pre_defined_functions.

1110

what are the nonstandard string types? : Sql dba

1082

What is the command used to fetch first 5 characters of the string?

1333

How long it takes to learn pl sql?

947

how to get @@error and @@rowcount at the same time? : Sql dba

968

What is clustered index sql?

930

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1039