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

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / malli

Answer Posted / malli

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which are the different types of indexes in sql?

990

How sql query is executed?

1064

What are triggers and its types?

995

What is procedure and function in sql?

927

What is secondary key?

880

who introduced sql?

947

What do you mean by “trigger” in sql?

1015

When is the explicit cursor used ?

977

What is the difference between python and sql?

937

What is the difference between truncate and drop statements?

1083

how can we destroy the session, how can we unset the variable of a session? : Sql dba

932

What is Histogram?

1503

what is dbms? : Sql dba

931

How to add a column ‘salary’ to a table employee_details?

953

Explain two easy sql optimizations.

959