You might need to read a good SQL primer to get a full explanation of
this feature.
Reading from the docs,
http://www.postgresql.org/docs/7.4/interactive/sql-select.html
The optional GROUP BY clause has the general form
GROUP BY expression [, ...]
GROUP BY will condense into a single row all s
Hi John,
John Sidney-Woollett schreef:
> Useful to add a title to your messages before you post...
It escaped before finishing.
> How about:
>
> select parentid, count(*) as number_of_children
> from childtable
> group by parentid
> order by parentid;
It works but can you tell me why this w