Posted by kengillett on 02/14/06 11:57

Aaron Lawrence wrote:
> 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.

Is it this simple?

Select top 1 column_a from table order by column_b desc

hth

[Back to original message]