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 asp.net?

1 Answers  


Is .net a programming language?

1 Answers  


Difference between dispose and finallize method?

1 Answers  


Can I write il programs directly?

1 Answers  


What is the procedure to add assemly to gac to make it shared one?

1 Answers  


Name the classes that are introduced in the system.numerics namespace.

1 Answers  


What's the use of system.diagnostics.process class in .net?

1 Answers  


I want to serialize instances of my class. Should I use xmlserializer, soapformatter or binaryformatter?

1 Answers  


Explain about .Net products?

1 Answers  


Explain what is the difference between web application and enterprise application?

1 Answers  


What does jit compilation do in .net?

1 Answers  


String[] a = new string[10] for(i=0; i<10; i++) { a[i] = i; } How many heap object will be created for this array. Choose the answer below. Ans: 1, 10, 11, 12

6 Answers  


Categories