Re: Question regarding count(*)

2001-04-20 Thread Steve Werby
<[EMAIL PROTECTED]> wrote: > 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 woul

Re: Question regarding count(*)

2001-04-20 Thread Fred van Engen
Hi, On Fri, Apr 20, 2001 at 03:01:25PM +0200, [EMAIL PROTECTED] wrote: > 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

Question regarding count(*)

2001-04-20 Thread Alexander . Haeussel
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 co