select top 1 salary from emp where salary <>( select top 1 salary f

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

Question Posted / deven

Answer Posted / deven

select top 1 salary from emp where salary <>(
select top 1 salary from emp order by salary desc) order by
salary desc

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are the differences between require and include, include_once and require_once? : Sql dba

1018

What is a Mapplet?

1116

How to display the current date in sql?

1070

What is sql basics?

1037

Is sql dba a good career? : SQL DBA

983

Can we use join in subquery?

1083

Does truncate require commit?

963

What is the syntax to add a record to a table?

1085

what is msql? : Sql dba

986

Can one improve the performance of sql*loader? : aql loader

1044

Explian rowid, rownum?

1007

What is the use of %rowtype?

1031

Is truncate ddl or dml?

989

What is normalisation in sql?

1049

Explain clause in sql?

1025