search

sanchezzzhak / kak-clickhouse

Yii2 ext. ClickHouse
69 stars 43 forks source link

swap buildWithTotals and buildHaving methods, because WITH TOTALS needs to be before HAVING #19

Closed demenkov closed 6 years ago

demenkov commented 6 years ago

https://clickhouse.yandex/docs/en/query_language/queries.html#select

SELECT [DISTINCT] expr_list [FROM [db.]table | (subquery) | table_function] [FINAL] [SAMPLE sample_coeff] [ARRAY JOIN ...] [GLOBAL] ANY|ALL INNER|LEFT JOIN (subquery)|table USING columns_list [PREWHERE expr] [WHERE expr] [GROUP BY expr_list] [WITH TOTALS] [HAVING expr] [ORDER BY expr_list] [LIMIT [n, ]m] [UNION ALL ...] [INTO OUTFILE filename] [FORMAT format]

sanchezzzhak commented 6 years ago

done