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.

• Next in forum: Select command with multiple tables
• Prev in forum: Re: fetching unique pins...
• Thread view: Re: select another column where max

[Reply to this message]