select max(salary) from emp_salary where salary<(select max(salary) fro

how to get second highest salary in SQL(as/4000

Question Posted / sachin

Answer Posted / sachin

select max(salary) from emp_salary where salary<(select
max(salary) from emp_salary);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the main features of cursor?

1041

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1062

What is the advantage of index in sql?

917

Is sql port 1433 encrypted?

974

what does the t-sql command ident_incr does? : Transact sql

1011

What is the difference between microsoft sql and mysql?

921

What is a natural join?

992

How do you determine the current isolation level? : Transact sql

1074

how to use regular expression in pattern match conditions? : Sql dba

966

What is normalisation in sql?

1005

What does truncate mean in sql?

964

Can we delete column in sql?

1026

what are the different tables present in mysql? : Sql dba

925

What is sql partition function?

1120

how to drop an existing index in mysql? : Sql dba

1018