Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 12103 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
Explain use of expression builder.
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is the difference between cartesian product and cross join?
How do you trace the traffic hitting a sql server?
How can we migrate from SQL server to SQL Azure?
Tell me something about security and sql azure?
Which Model uses the SET concept
How to change the name of a database user?
What are the disadvantages of using querystrings to send data from one page to another?
What is sql view?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Can you name some of the dml commands in sql?
What is use of except clause? How does it differ from not in clause?
What are the different types of collation sensitivity?
How can I change procedure name in sql server?
