clickhouseSelect sumIf query example
SELECT sumIf(age, date < '2022-01-01') FROM tblctrl + csumIfsum specified column value if expression is | agename of the column to sum |
date < '2022-01-01'expression to check (should we add this row value to the total sum) | tbltable to select data from |
Usage example
SELECT sumIf(age, date < '2022-01-01') FROM tbloutput
┌─sumIf(age, less(date, '2022-01-01'))─┐
│ 125 │
└──────────────────────────────────────┘More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Select countIf usage example
- Create table example
- String concat
- Add row number to results
- List all tables from all database
- Create table with UUID column
- Select where date column is between dates
- Select rows with certain value in array column
See more codes...