Rob Dixon schreef: > Mr. Shawn H. Corey wrote: >> SELECT company, COUNT(*) >> FROM commitCurrent >> GROUP BY company; > > Someone else has personal standards for SQL! Thank you Shawn!
Do you keep a list of them? I would write it as
SELECT
c.company
, COUNT(*) AS n
FROM
commitCurrent AS c
GROUP BY
c.company
;
--
Affijn, Ruud
"Gewoon is een tijger."
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
