select top 1 sal from emp where sal not in (select top 1 sal from emp ord

how to find the second highest salary from emp table?

Question Posted / raju

Answer Posted / raju

select top 1 sal from emp
where sal not in (select top 1 sal from emp order by sal
desc ) order by sal desc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to drop an existing index in mysql? : Sql dba

1018

How to avoid duplicate records in a query?

952

Explain clause in sql?

962

Explain architecture of sql server notification services?

988

What do you think about pl/sql?

950

What are the operators in sql?

973

define join and explain different type of joins? : Sql dba

900

What is linq to sql?

1061

Why we use triggers in mysql?

938

what is index? : Sql dba

945

What is mutating table error?

1118

What are different types of triggers?

1029

Does oracle roll back the transaction on an error?

962

What is auto increment feature in sql?

1068

Why cross join is used?

1024