Skip to main content
Skip to main content

system.one

This table contains a single row with a single dummy UInt8 column containing the value 0.

This table is used if a SELECT query does not specify the FROM clause.

This is similar to the DUAL table found in other DBMSs.

Example

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free