select * from emp a where 2=(select count(distinct(sal)) from emp b where a

find 2nd highest salary of person using cursor concept?

Question Posted / pawan

Answer Posted / pawan

select * from emp a where 2=(select count(distinct(sal)) from emp b where a.sal<=b.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to use the inserted and deleted pseudo tables?

925

Where can you add custom error messages to sql server?

1065

What do you need to connect php to sql server?

1060

What can be used instead of trigger?

1113

What are the authentication modes in sql server? How can it be changed?

1068

Explain partitioned view?

1034

What is inner join? Explain with an example?

1132

What is the difference between SQL notification and SQL invalidation?

1100

Difference between drill down and drill through report.

906

How to create “dependant” parameter “make, model, year”

125

What is deploy, process and build? : sql server analysis services, ssas

1054

What are the different types of join?

1117

What are the advantages of the mirroring?

1032

Can the query output be sorted by multiple columns in ms sql server?

947

What are the disadvantages of primary key and foreign key in SQL?

1069