select max(sal) frem tbl where sal <(select max(sal) from tbl;

find 2nd highest salary of person using cursor concept?

Question Posted / krish

Answer Posted / krish

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is Service Broker in sql server 2012?

1022

What is constraints and its types?

952

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1092

How to create a new schema in a database?

1151

Does a full backup include transaction log?

979

Where can you find the error log information? : sql server database administration

1029

What is bcp? When does it used?

979

Explain temporary table vs table variable by using cursor alternative?

1001

What is difference between standardization and normalization?

1105

What is Federation Root Database?

104

What is use of @@ spid in sql server?

1213

how you can move data or databases between servers and databases in sql server? : Sql server administration

969

Define union, union all, minus, intersect?

982

What stored by the tempdb ? : sql server database administration

1052

What is transaction server implicit?

1015