Very much answered. Thanks a mil. >>> "Uffe Kousgaard" <[EMAIL PROTECTED]> 01/15/04 09:59AM >>> 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD> <BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px"><FONT size=1>Very much answered. Thanks a mil.</FONT><BR><BR>>>> "Uffe Kousgaard" <[EMAIL PROTECTED]> 01/15/04 09:59AM >>><BR>To do that, you will have to add a field called "ID", update it to contain<BR>rowid (i.e. 1, 2, 3,....) and then include a where clause in your SQL:<BR><BR>where rowid<=20<BR>or<BR>where rowid>=20 and rowid<=100<BR><BR>If you want to see only the top 20 records in the output (i.e. after the<BR>group by), then the answer is no. MapInfo SQL doesn't handle that in a<BR>single step. With 2 steps you can do something similar to what I have<BR>written above.<BR><BR>Kind regards<BR><BR>Uffe Kousgaard<BR>www.routeware.dk<BR><BR><BR>Norman Mabunda wrote:<BR>><BR>> Another question: Is't possible 1000 records count to see only a<BR>> certail number of records. For instance, of the 100 records count, to<BR>> see the 1st 20 records, or to see only 20 records of the 100 records.<BR>> If yes, how?<BR><BR><BR>---------------------------------------------------------------------<BR>List hosting provided by Directions Magazine | www.directionsmag.com |<BR>To unsubscribe, e-mail: [EMAIL PROTECTED]<BR>For additional commands, e-mail: [EMAIL PROTECTED]<BR>Message number: 9895<BR><BR></BODY></HTML>
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9897