clickhouseSelect where date column is between dates
SELECT * FROM tbl WHERE date BETWEEN '2022-01-11' AND '2022-01-20'ctrl + ctblsample table to select data from | datecolumn of Date type |
BETWEENfilter based on specified values range | '2022-01-11'start with this value |
'2022-01-20'end with this value | |
Usage example
SELECT * FROM tbl WHERE date BETWEEN '2022-01-11' AND '2022-01-20'output
┌───────date─┬─col────┬─val─┬─age─┐
│ 2022-01-11 │ Donald │ 0 │ 0 │
│ 2022-01-11 │ Donald │ 0 │ 0 │
│ 2022-01-12 │ Donald │ 0 │ 0 │
└────────────┴────────┴─────┴─────┘