Steve Holden wrote in news:mailman.3804.1226412496.3487.python-
[EMAIL PROTECTED] in comp.lang.python:
>> Shouldn't it be GROUP BY master.id? I would have thought that SQL
>> would be sad about a non-aggregate (master.id) that's in the SELECT
>> list but not also in the GROUP BY list.
>>
> Well, I did say "untested". But in SQL Server, for example, any field
> argument to COUNT() must be an aggregated column. So it may depend on
> the SQL implementation. I should really have said
You must mean an "SQL Server" other than the Microsofts one, as:
select count( aid ) as "count"
from table_1
group by aid
count
-----------
8
8
8
8
8
8
8
8
(8 row(s) affected)
and:
select count( aid ) as "count"
from table_1
count
-----------
64
(1 row(s) affected)
Like it should.
Rob.
--
http://www.victim-prime.dsl.pipex.com/
--
http://mail.python.org/mailman/listinfo/python-list
