select max(salary) from Emp where salary<(select max(salary) from Emp)

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

Question Posted / srinivas

Answer Posted / srinivas

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql a programming?

1029

how to create a new table in mysql? : Sql dba

1035

Does sql backup shrink transaction log?

1045

Explain the commit statement.

1215

Is there any restriction on the use of union in embedded sql?

1200

Why do we need cursors in pl sql?

1160

What is the difference between left join and right join?

990

how to include character strings in sql statements? : Sql dba

1142

What is sql query optimization?

1195

What are field types?

1055

What are the different schemas objects that can be created using pl/sql?

1085

Which nosql database is best?

1025

Why functions are used in sql?

1044

What is a sql profiler?

1066

What is t sql used for?

1062