select * from tabl1 where salary=(select max(salary) from tabl1 where sala

find 2nd highest salary of person using cursor concept?

Question Posted / b.mamatha

Answer Posted / b.mamatha

select * from tabl1 where salary=(select max(salary) from
tabl1 where salary<(select max(salary) from tabl1)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the different types of data sources in ssrs?

196

What is user-defined scalar function?

950

explain how to create a new schema in a database? : Sql server database administration

1095

What is merge statement?

1067

What are commonly used odbc functions in php?

1001

How to create a simple table to test triggers in ms sql server?

962

What are parameterized reports? What are cascading parameters in ssrs reports?

156

Tell me what is sql profiler?

1012

What is blocking and how would you troubleshoot it? : sql server database administration

1031

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1016

What is self contained sub query?

1008

What is SQL Azure Fabric?

110

Explain the types of indexes.

1182

what is the system function to get the current user's user id? : Sql server database administration

994

What is in place upgrade in sql server?

1027