clickhouseAdd row number to results
SELECT rowNumberInAllBlocks(), * FROM tbl;ctrl + crowNumberInAllBlocksreturns current row number | FROM tblsample table to select data from |
Usage example
SELECT rowNumberInAllBlocks(), * FROM tbloutput
┌─rowNumberInAllBlocks()─┬───────date─┬─col────┐
│ 0 │ 2022-01-07 │ Donald │
│ 1 │ 2022-01-10 │ Donald │
│ 2 │ 2022-01-11 │ Donald │
│ 3 │ 2022-01-11 │ Donald │
│ 4 │ 2022-01-12 │ Donald │
...More of Clickhouse
- Convert array to rows
- Select where date column is between dates
- How to restart Clickhouse server
- Using variables in queries
- How to execute SQL query from a file
- Get total database size
- Select sumIf query example
- Convert array to string
- List table partitions
- Show running queries
See more codes...