You can do it with two quaries, like so..
(Copy following lines into your MapBasic window, insert your table and
column names, select all pasted lines and hit <Enter>)
Dim nrows As Integer
nrows = TableInfo(YourTableNameHere,8)
Select * From YourTableNameHere Order By YourColumnNameHere Into Tmp
Select * From Tmp Where RowID < nrows/10 Into Temp
UnDim nrows
Regards
Anssi
>At 12:05 16.2.1999 -0500, you wrote:
>>This might be a simple question but I have a table of properties which has a
>>list of property values and I would like to find the top 10% properties using
>>the assesment values.
>>Does anyone know how to do this using SQL?
>>
>>
>>
>>----------------------------------------------------------------------
>>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>>"unsubscribe MAPINFO-L" in the message body, or contact [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]
