select max(salary) from employees where salary not in (select max(salary)

how to find the second highest salary from emp table?

Question Posted / raju tt

Answer Posted / raju tt

select max(salary) from employees where salary not in
(select max(salary) from employees)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the types of subquery? : Sql dba

1102

Is id a reserved word in sql?

1141

Why commit is not used in triggers?

1038

What does data normalization mean?

953

What is record variable?

986

What is sql profiling in oracle?

1059

Is sql harder than python?

1098

How exception handling is done in advance pl/sql?

979

what are the performance and scalability characteristics of mysql? : Sql dba

996

What is left join example?

945

What is the main reason behind using an index?

1014

How do rank () and dense_rank () differ?

1044

Where is sql database stored?

979

Why do we use subquery?

1010

What are the advantages of normalization?

1077