select min(salary) from tblempsal where salary in(select distinct top 2

how to find the second highest salary from emp table?

Question Posted / shanmugasundaram

Answer Posted / shanmugasundaram

select min(salary) from tblempsal where salary in(select
distinct
top 2 salary from
tblempsal order by salary desc)

Is This Answer Correct ?

20 Yes

13 No

Please Help Members By Posting Answers For Below Questions

Does access use sql?

970

What is cartesian join in sql?

1030

Differentiate pl/sql and sql?

1013

What is cursor and its types?

996

How do I install sql?

943

How to fetch alternate records from a table?

1160

What is dml statement?

902

Can we update views in sql?

899

What is having clause in sql?

929

what are aggregate and scalar functions? : Sql dba

996

What is sql resultset?

934

What are tables in sql?

999

What are the types of keys?

935

What is time based sql injection?

904

What is anonymous block in sql?

1076