Help wanted!
The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.
数字
numbers(N)
– Returns a table with the single ‘number’ 0からN-1までの整数を含む列(UInt64)。
numbers(N, M)
-単一のテーブルを返します ‘number’ nから(N+M-1)までの整数を含む列(UInt64)。
に類似した system.numbers
テーブルに使用でき試験および発生連続値, numbers(N, M)
より有効 system.numbers
.
次のクエリは同等です:
SELECT * FROM numbers(10);
SELECT * FROM numbers(0, 10);
SELECT * FROM system.numbers LIMIT 10;
例:
-- Generate a sequence of dates from 2010-01-01 to 2010-12-31
select toDate('2010-01-01') + number as d FROM numbers(365);