clickhouseCount unique values
SELECT uniq(col) FROM tblctrl + cuniqwill return count of unique values of a given column | colcolumn to count unique values in |
tblsample table | |
Usage example
SELECT uniq(col) FROM tbloutput
┌─uniq(col)─┐
│ 9 │
└───────────┘Related
More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Select countIf usage example
- Add row number to results
- Create table example
- String concat
- List all tables from all database
- Select rows with certain value in array column
- Create table with UUID column
- Insert array of strings in CSV format
See more codes...