clickhouseSelect distinct values
SELECT DISTINCT col FROM tblctrl + cDISTINCTwill filter out only unique values of specified column | colcolumn to get unique values of |
tblsample table to select data from | |
Related
More of Clickhouse
- List all users
- Get total database size
- Get table size
- List all tables from all database
- Create AggregatingMergeTree materialized view
- How to select based on Tuple element value
- Select sumIf query example
- Using variables in queries
- Add row number to results
- List all databases
See more codes...