mfyeung_home wrote:

> Can anyone tell me how to fetch the first 100 records in a select
> statement?

select first 100 Col1, Col2, ...
from ...

You can also do:

select first 100 skip 100 Col1, Col2, ...
from ...

to get the next 100 (101:st to 200:th) records.

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64