Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 11644 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
Why we should not use triggers?
What are constraints?
What is difference statement and preparedstatement?
What is faster join or union?
What is difference between inner join and full join?
What does ss stand for sexually?
What encryption security is available in sql azure?
How much is a sql server license?
What is dirty read?
Is foreign key unique?
What are the types of subquery?
Explain the concept of view and Types of views in SQL server?
What is sub-query in sql server? Explain its properties.
What are built in functions?
What are the steps you will take to improve the performance of a poor performing query?
