Hi Folks,
i have a question regarding the handling of the count()
option in a sql-statement.
i have the following statement:
select distinct(ip), count(*) from log group by ip
This gives me a table with 2 columns and i want to
it sorted by the count(*) column. How would i do that??
...order by count(*) is not an option because it results
in an error saying that count(*) does not exist.
tia
alex
---
Alexander Häussel
God said: tar xfvz universe.tar.gz - and the Universe was!
celsius37.com AG Email
mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php