> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing a single row with a single `dummy` UInt8 column containing the value 0. Similar to the `DUAL` table found in other DBMSs.

# system.one

<h2 id="description">
  Description
</h2>

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.

<h2 id="columns">
  Columns
</h2>

{/*AUTOGENERATED_END*/}

<h2 id="example">
  Example
</h2>

```sql theme={null}
SELECT * FROM system.one LIMIT 10;
```

```response theme={null}
┌─dummy─┐
│     0 │
└───────┘

1 rows in set. Elapsed: 0.001 sec.
```