select top 1 salary from emp where salary in (select top 2 salary from emp

how to find the second highest salary from emp table?

Question Posted / vikas

Answer Posted / vikas

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are triggers and its types?

1120

How do you truncate?

955

What is data abstraction in sql?

1066

What is a primary key example?

1002

What is foreign key sql?

1039

Why do we use %rowtype & %type in plsql?

1099

What is difference between my sql and sql?

1139

What trigger means?

1036

What is rownum?

1034

What does data normalization mean?

1028

What is dml and ddl?

1009

How do you modify a column in sql?

1053

what is a record in a database ? : Sql dba

1105

Do ddl statements need commit?

1023

explain advantages of innodb over myisam. : Sql dba

1175