Re: Why might this statement only return one row

[Peter Brawley]

Please read the manual pages on aggregation and Group By. Count() aggregates across rows. That gets you one result row unless you add a Group By clause. The query ...

select *, count(id) ...

is incoherent. If you just want the count, just ask for it. If you want it broken out across particular values of some column, add that column and add a Group By clause that cites that column.