Hi Adi Yes it is possible, but you have to use 2 select sentens, try this 1: Select TownId, Area(obj, "sq km") from MyTab where group by 2 into TownLst 2: select * from TownLst where rowid < 101 Peter Laulund National Survey and Cadastre, Denmark "Adi" <[EMAIL PROTECTED]> - 07-01-99 10:25:46 Til: [EMAIL PROTECTED] cc: (bcc: Peter Laulund/MI/KMS) Vedr�rende: About MI
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? Thanks in advance Aditya Executive (Systems) Information Systems Department [E-mail me at [EMAIL PROTECTED]] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
