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
- 22595 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
Tell me what is de-normalization and what are some of the examples of it?
What is the Disadvantage of indexed sequential file.
Do you know what is sql service broker?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are different types of subquery?
What is trigger and different types of Triggers?
Where to find ntwdblib.dll version 2000.80.194.0?
What is database architecture? : SQL Server Architecture
How to write a query with a full outer join in ms sql server?
What is 1nf 2nf and 3nf?
How can I check that whether automatic statistic update is enabled or not?
How do you trace the traffic hitting a sql server?
What is the difference between dropping a database and taking a database offline?
When you use @@error and try-catch?
