SQL ENQUIRY In how to Get defined number of records
- by ramadan2050
I have a select statement, retrieve about 1000 record
I want to modify it to return only some records defined by @startIndex and @count
e.g. : If I said @startIndex=20 and @count=20
the result will be : from the 21th record to 40th
I try to make it, but it take the same time as if I retrieve the 1000 record
what is the best way to do that