ClickHouse playground

create table data (id UInt32, x UInt32)
engine MergeTree order by id sample by id
as

select number+1 as id, randUniform(1, 100) as x
from numbers(10000);

select
  avg(x) as "avg",
  round(quantile(0.95)(x), 2) as p95
from data
sample 0.1;

ClickHouse is an open source columnar database management system optimized for real-time data analysis of large datasets.

⛫ homepage • αω tutorial • ⚘ community

Sandbox details

ClickHouse version: 23.10
sandbox engine:     codapi
sandbox name:       chdb
allowed commands:   run
in-browser:         ✘

Usage example:

```sql
select 'Hello, World!' as message;
```

<codapi-snippet sandbox="chdb" editor="basic">
</codapi-snippet>

Documentation