Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 11725 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / manju
DECLARE authors_salary CURSOR
select top2(salary) from tb_employee order by desc salary
open author_salary
FETCH NEXT FROM authors_salary into @topsalary
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Tell me extended events in sql server 2008?
Explain view in sql server?
List out the different types of locks available in sql server?
what are user defined datatypes? : Sql server database administration
how to take backup bcp out for a column in table in sql server?
Explain what is the purpose of sql profiler in sql server?
What is mssql?
Can a table be created inside a trigger?
Is resultset an interface?
What happens when unicode strings concatenate with non-unicode strings?
what is raid and what are different types of raid configurations? : Sql server database administration
What are indexers?
Is ssrs support other database except ms sql server?
can you implement data mining in SSRS?
What happens if null values are involved in comparison operations?
