Limit the retrieved result of a select...

[mitch77]

I have made a select, that retrieves +/- 3000000 records, and i would like to know how can i fetch the records retrieved, for example the first 100 records, the next 100 records, etc...

thanks, Mitch

 

[sgursahaney]

Mitch:
Take a look at the FETCH FIRST x ROWS clause which allows you to retrieve a certain number of rows. But, if you are trying to retrieve the rows in batches you may have to use a cursor.