To do that, you will have to add a field called "ID", update it to contain rowid (i.e. 1, 2, 3,....) and then include a where clause in your SQL:
where rowid<=20 or where rowid>=20 and rowid<=100 If you want to see only the top 20 records in the output (i.e. after the group by), then the answer is no. MapInfo SQL doesn't handle that in a single step. With 2 steps you can do something similar to what I have written above. Kind regards Uffe Kousgaard www.routeware.dk Norman Mabunda wrote: > > Another question: Is't possible 1000 records count to see only a > certail number of records. For instance, of the 100 records count, to > see the 1st 20 records, or to see only 20 records of the 100 records. > If yes, how? --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9895