Postgres Pro
Downloads
Home   >   mailing lists

Thread: problem - group by

problem - group by

From
Dusan PESL
Date:
Hello,

I have found the solution of "GROUP BY" problem. Instead of:

SELECT acount/1000, SUM(values) FROM acounts
GROUP BY acount/1000

this query works:

SELECT acount/1000 AS acount_1000, SUM(values) FROM acounts
GROUP BY acount_1000

so, forget my previous question...

Best regards Dusan