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]
