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

What is difference between stored function and application function?

1195

What are all different types of collation sensitivity?

1029

Can a procedure in a package be overloaded?

1043

How to sort the rows in sql.

1072

what is a unique key ? : Sql dba

1089

how many values can the set function of mysql take? : Sql dba

984

Is drop table faster than truncate?

985

What is the difference between jpql and sql?

1092

Can we insert in sql function?

1081

Is coalesce faster than isnull?

966

Can we use pl sql in mysql?

1010

What is the difference between rollback and rollback to statements?

1060

What is the sql*loader? : aql loader

1051

Which sorts rows in sql?

1016

What is a design view?

921