select max(salary)from m1 where salary <>(select max(salary) from m1

how to find the second highest salary from emp table?

Question Posted / hitesh pundir

Answer Posted / hitesh pundir

select max(salary)from m1 where salary <>(select max(salary)
from m1)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is bind reference and how can it be created?

967

what does myisamchk do? : Sql dba

963

How do you clear the screen in sql?

1012

what tools available for managing mysql server? : Sql dba

1011

What is composite data type in pl sql?

1035

What is the usage of when clause in trigger?

992

what is dbms? : Sql dba

934

Does truncate free space?

948

Is json a nosql?

917

what is bcp? When is it used?

1049

What is varray in pl sql?

1008

What are field types?

942

What is function and procedure in pl sql?

975

what are the limitations of identity column? : Transact sql

1052

what is the difference between where clause and having clause? : Sql dba

950