select max(salary) from tbl where salary not in (select max (salary) from

find 2nd highest salary of person using cursor concept?

Question Posted / amruta dash

Answer Posted / amruta dash

select max(salary) from tbl where salary not in (select max
(salary) from tbl);

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the difference between value type and reference type?

872

Where sql server user names and passwords are stored in sql server? : sql server database administration

994

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2426

What is 2nf normalization?

970

Do you know what is lock escalation?

963

Explain view in sql server?

1009

What is executereader?

898

how would you troubleshoot blocking? : Sql server database administration

945

How to make remote connection in database?

956

What is federation member?

114

What is a view in sql?

929

What is bookmark link in ssrs?

234

Can you import Microsoft Excel data to SSRS?

125

What happens if time-only values are provided as date and time literals?

954

What is a DBMS, query, SQL?

998