|
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
Navigation:
[Reply to this message]
|