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 / venkat

Answer Posted / venkat

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

Is This Answer Correct ?

19 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Sql technical questions

1336

how to create a test table in your mysql server? : Sql dba

1057

How to avoid using cursors?

1179

How to write a query to show the details of a student from students table whose

1063

what are the different type of sql's statements ? : Sql dba

980

What is java sql driver?

1186

Is sql low level language?

1067

What is field delimiter?

1114

How to make a copy values from one column to another in sql?

1084

How to rename a table?

1076

what is the difference between truncate and delete statement? : Transact sql

1122

What does the base_object_type column shows in the user.triggers data dictionary view?

1099

tell me about various levels of constraint. : Sql dba

1077

Explain the select statement in sql?

1185

What steps server process has to take to execute an update statement?

1020