Hi Tony,
You can certainly do this with a sub select against the same table. If the
column is not indexed, you may need to watch performance on it though.
Here's the syntax against the state table using population.
select * from states where pop_1990 = (select min(pop_1990) from states)
Hope this is helpful.
Joe Moore
At 05:20 PM 2/2/99 +1000, Tony Kelava wrote:
>Hi all,
>
>I have a table as follows (example):
>
>ID Dist ID_2
>1 20 102
>1 24 103
>1 45 111
>
>I want to create a table that only contains the ID, minimum DISTvalue
>and associated ID_2 value.
>
>For example, new table ONLY contains the row of info:
>
>ID Dist ID_2
>1 20 102
>
>and disregards the other 2 rows.
>
>Can this be done easily. I have about 80,000 records in the database.
>
>Regards
>
>Tony
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
Joseph Moore
Sr. System Analyst
Forth & Associates Product Development
919.467.3440
888.427.2403
http://www.transfinder.com
[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]
