find 2nd highest salary of person using cursor concept?
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 the difference between control flow and data flow?
How do you manipulate data?
List out some of the requirements to set up a sql server failover cluster?
Tell me what is the order in which the sql query is executed?
Which is the main third-party tool used in sql server?
What is the difference between truncate and delete commands?
Introduction of rollup clause using sum and group by clause?
What is schemabinding a view?
What are the advantages dts has over bcp?
Why should you use or avoid select * statements?
What is field with example?
How to list all login names on the ms sql server?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How can you list all the table constraints in a database?
What is the largest component inside a field?