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 different tcl commands in sql?

1232

Is null operator in sql?

1094

What is pls integer?

1093

Explain isolation levels. : Transact sql

1109

Is pl sql still used?

1018

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

1034

What is data profiling in sql?

1139

Explain the commit statement.

1215

How to process query result in pl/sql?

1202

Define tables and fields in a database

1181

How do I remove duplicates in two columns?

1150

what is dbms? : Sql dba

1036

Inline the values in PL/SQL, what does it mean.?

1275

How do I view a table in sql?

1043

What is indexing in sql and its types?

1141