Write code for fetch record nos 15 to 25 from a dataset
containing 50 records?

Answers were Sorted based on User's Feedback



Write code for fetch record nos 15 to 25 from a dataset containing 50 records?..

Answer / monika

insert a new column "Rowid int identity" and then you can
access the data with the query like

select * from tablename where rowid >=15 and rowid<=25

Is This Answer Correct ?    5 Yes 0 No

Write code for fetch record nos 15 to 25 from a dataset containing 50 records?..

Answer / kinjal

one extra int field add in database and set identity.
if that datafield name is id then write the query

select * from database_table where id>=15 and id<=25.

Is This Answer Correct ?    1 Yes 0 No

Write code for fetch record nos 15 to 25 from a dataset containing 50 records?..

Answer / pradeep kumar mishra

select * from DATABASE_NAME where nos>='" & 15 & "' and
nos<='" & 25 & "'

Is This Answer Correct ?    2 Yes 4 No

Write code for fetch record nos 15 to 25 from a dataset containing 50 records?..

Answer / nithyananthababu

We can use the ROW_NUMBER Proberty from sql 2005

We can easily get the data's via roll numbers

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Dot Net General Interview Questions

What are an object and a class?

0 Answers  


What are the differences between com architecture and.net architecture?

0 Answers  


What is PageIndex in DataGrid?What is the event used in the Datagrid for while moving from one page to another page in the Grid?write code for it

2 Answers  


Tell us what is heap and what is stack?

0 Answers  


State some of the different languages supported by .net?

0 Answers  






Explain acid properties?

1 Answers  


How Garbage Collector (GC) Works?

1 Answers  


What is operator overloading in .net?

0 Answers  


What is a serviced component?

0 Answers  


What are the challenging issues you have faced in implementation project/Maintainance project in .net Functionality? How you have overcome that issue?

0 Answers   TCS,


Is .net an object oriented language? What are their components?

0 Answers  


What is CCW (COM Callable Wrapper) ?

1 Answers  


Categories