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

What can be used instead of trigger?

1131

What is policy based management (pbm)? : sql server database administration

962

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

950

plss anybody specify tha constrian management system in dbms

2127

what's the difference between a primary key and a unique key? : Sql server database administration

923

How to disable triggers using "disable trigger"?

1033

How to change a login name in ms sql server?

1064

What is PROJECTION Operation?

1005

Explain Normalization and DE normalization

1093

What are the advantages of mirroring?

970

What are the differences between ms sql server & oracle?

1036

What are the advantages of sql stored procedure?

1052

what are isolation levels? : Sql server database administration

969

What is meant by Active-Passive and Active-Active clustering setup?

1144

What is an etl file?

942