Write code for fetch record nos 15 to 25 from a dataset
containing 50 records?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / pradeep kumar mishra
select * from DATABASE_NAME where nos>='" & 15 & "' and
nos<='" & 25 & "'
Is This Answer Correct ? | 2 Yes | 4 No |
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 |
What is portable executable (PE)?
What is Full trust permission set in .Net
Please explain what are an inheritance, polymorphism, and encapsulation?
What is difference between static page and dynamic page?
Can you create instance of a class which has private constructor?
Explain me how does linq work?
How many types of generations are there in a garbage collector?
How inheritance works in .net?
Is .net capable of supporting multi-thread?
Explain the difference between the stack and the heap?
Explain code access security.
What is .net code security?