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

What is auto increment in sql?

1061

what are all the different types of indexes? : Sql dba

996

What are the rules to be applied to nulls whilst doing comparisons?

1273

What is recursive stored procedure?

1046

What is rowtype?

954

Can we join more than 2 tables in sql?

946

What is output spooling in sql*plus?

983

What are operators available in sql?

979

Is coalesce faster than isnull?

907

How is a PL/SQL code compiled?

1171

what are date and time data types? : Sql dba

930

How to handle bulk data?

1269

What is sql indexing?

964

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

916

What is the difference between a query and a report?

901