select top 1 salary from t1 where salary in(select top 2 salary from t1 or

how to find the second highest salary from emp table?

Question Posted / hitesh

Answer Posted / hitesh

select top 1 salary from t1 where salary in(select top 2
salary from t1 order by salary desc)order by salary asc

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Why we use sql profiler?

963

Can we join 3 tables in sql?

1049

Is and as keyword in pl sql?

963

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

1062

what is a cursor? : Sql dba

1029

tell me about various levels of constraint. : Sql dba

1035

How do I find duplicates in the same column?

1100

explain what is mysql? : Sql dba

1088

Is delete faster than truncate?

1006

What does fetching a cursor do?

1096

what is a database lock ? : Sql dba

1175

How insert into statements in sql?

1081

what is cross join? : Sql dba

1004

What are the benefits of triggers?

1175

Why is a trigger used?

947