Posted by Aaron Lawrence on 02/15/06 07:36

kengillett@gmail.com wrote:
> Select top 1 column_a from table order by column_b desc

Hi Ken,
Thanks for the suggestion. That is quite good but I would rather not use
Microsoft-specific syntax.

• Next in forum: Re: Non-English Characters
• Prev in forum: Re: select another column where max
• Thread view: Re: select another column where max

[Reply to this message]