Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 11822 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 are commonly used odbc functions in php?
What are the restraints imposed on the table design by a merge replication?
Explain what are the different index configurations a table can have?
how you can list all the tables in a database?
What is the need for group functions in sql?
How to list all login names on the ms sql server?
what is database replicaion? : Sql server database administration
How to receive output values from stored procedures?
How to retrieve error messages using odbc_errormsg()?
What is the command used to recompile the stored procedure at run time?
Write the SQL query to drop, truncate and delete table.
Define outer join?
What is the difference between indexing and hashing?
write an SQL query to list the employees who joined in the month of January?
What is Dependency Injection and provide example?
