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

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

982

How to rebuild indexes with alter index ... Rebuild?

1062

What is normalization? Explain different forms of normalization?

1092

List the different types of joins?

947

What is the difference between online clustering and Offline clustering?

2378

explain declarative management framework (dmf) in sql server 2008?

959

What are the differences between triggers and stored procedures?

1011

What is raid? : SQL Server Architecture

1125

What is nolock hint in sql server 2008

1097

What is an example of a foreign key?

943

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1010

How can we delete Duplicate row in table?

1019

What is data file in computer?

907

How use inner join in sql server?

1076

which table keeps the locking information? : Sql server administration

1030