in reply to Re: ORDER BY COUNT(*)?
in thread ORDER BY COUNT(*)?

In mySQL you need to use the AS keyword to name a column, ie count(*) AS col2. After that, this method works fine.

This page is intentionally left justified.

Replies are listed 'Best First'.
Re: Re: Re: ORDER BY COUNT(*)?
by aersoy (Scribe) on Mar 20, 2002 at 18:40 UTC
    No, AS keyword is optional. The above query is perfect.
[reply]

In Section Seekers of Perl Wisdom