Обсуждение: problem - group by

Поиск
Список
Период
Сортировка

problem - group by

От
Dusan PESL
Дата:
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