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

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

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

[Reply to this message]