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

how to find the second highest salary from emp table?

Question Posted / sreenadh reddy

Answer Posted / sreenadh reddy

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

Is hadoop a nosql?

1004

Does sap use sql?

993

Which table is left in join?

978

What is auto increment in sql?

1121

Can we use two order by clause in query?

967

What is the use of partition by in sql?

994

Is left join same as join?

993

what happens if you no create privilege in a database? : Sql dba

1001

What is the difference between an inner and outer join?

1012

What is right join in sql?

1090

What are the operators used in select statements?

1058

Can you join a table to itself?

1132

Does mysql_real_escape_string prevent sql injection?

946

What are two statement types in sql?

1104

How do I remove duplicates in two columns?

1065