Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
- 16 Answers
- 25224 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / uma
this is uma sorry the above is wrong.
pls the is the correct answer ,i have this answer
declare cursor on table ,after that open the cusor and
using "fetch" keyword we retrive any row ,and we have
remove the cursor explictly because it is stored in the
memory pls use dellocate keyword
declare cursou_emp2 insensitive scroll cursor for select *
from empdetails [for{readonly}]
open cursou_emp2
fetch absolute 15 from cursou_emp2
deallocate cursou_emp2
it will display 15th row, if u wnt any row u chnage instead
of 15
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain acid?
What is postgresql server?
What is user-defined multi-statement table-valued function?
Can we write trigger for view?
Tell me what are cursors and when they are useful?
Do you know what is a trace frag? Where do we use it?
How to remove duplicate rows from table except one?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What are the advantages of using cte?
How to check status of stored procedure in sql server?
Does index speed up select statements?
How to encrypt Strored Procedure in SQL SERVER?
What is sql server query analyzer?
What is index fragmentation in ms sql server?
How do you implement session management in SQL Server mode?
