is there a way to have identical data in a table and order it by the greatest numeric value?<BR><BR>
It seems to me that if you have identical data in a table, the numeric values will also be identical. But anyway, you can always order your result:<BR><BR>SELECT * FROM MyTable ORDER BY MyNumericColumn DESC
the highest numeric values???
select max(name),max(number) from mytable<BR><BR>group by name<BR>