Posted by Aaron Lawrence on 02/14/06 10:52

MGFoster wrote:
> SELECT column_a, MAX(column_b)
> FROM table_name
> GROUP BY column_a

Huh? Won't that show me the max of column_b for every value of column_a.
I only want to see the ONE value of column_a where column_b is at max.

[Back to original message]