Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Explain the Difference between value and reference type.

2 Answers   Infosys, Wipro,


what is the keyword used for self reference?

0 Answers  


What is Assembly manifest? what all details the assembly manifest will contain.

2 Answers   Ksb,


Explain how com+ related to the dna architecture?

0 Answers  


What is the use com component in .net?

0 Answers  






<li id="Accomodation" runat="server" visible="false"><a href="../searchaccommodation.aspx?">Accomm</a></li> i have this code.now on server side i want to compare this id(Accommodation) value and want id i.e.Accommodation.visible=true;

0 Answers  


What are the contents of assembly?

4 Answers   ABC, Ksb,


Difference between machine.config and web.config?

0 Answers  


How to prepare parametrized (with more than one parameters) crystal report.pls tell me the code procedure, if any body can?

0 Answers  


Name for built-in permission sets in .Net

1 Answers  


What is the difference between override and overload in a method?

0 Answers  


What is the benefit of .net core?

0 Answers  






Categories