Hello Adi,
> Can I select top 100 towns from a table.
> (I have a table containing say 1000 records and I
> want those towns which fall in top 100 in terms
> of area (or whatever it is) ) Is it possible?
Perform an SQL select using the "order by" option to sort your ~1000 records by
something. For
areas you will probably need to add the "desc" keyword to get a descending sort
(largest
area first). Name the result table "ALL_SORTED" or something like that. Then do
another SQL
select on the ALL_SORTED table with a "where" clause of "rowid <= 100". rowid is a
special
"internal" field which gives each record a unique numerical ID, starting from 1. This
where clause
will just take the top 100. The result table will contain your desired records - you
can even save if
required.
Regards,
Warren Vick
Europa Technologies Ltd, U.K.
www.europa-tech.com
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
