Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 11915 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
What is the Main Difference between ACCESS and SQL SERVER?
What is apply operator in sql?
Equi join and non equi join is possible with sql server?
What is function of CUBE ?
Explain about Normalization?
Which data type columns are the best candidates for full-text indexing?
Can you explain what is indexed view? How to create it?
How we can refresh the view?
How to read data in a table with "select" statements?
What are information schema views?
What is data file in computer?
How does index makes search faster?
What is difference between cte and view?
What are different types of roles provided by ssrs?
What is the use of floor function in sql server?
