create table test(id int, id2 int, status String) Engine=Memory
as select number,number, ['approved', 'completed'][number%3] from numbers(10);
select ROUND(count(distinct case when status = 'approved' then id else null end)/count(distinct id2) * 100) as "SR- txns"
from test
┌─SR- txns─┐
│ 30 │
└──────────┘
Clickhouse风格的语法:
select ROUND(uniqExactIf(id,status = 'approved')/uniqExact(id2) * 100) as "SR- txns"
from test
┌─SR- txns─┐
│ 30 │
└──────────┘
1条答案
按热度按时间yizd12fk1#
但它的工作原理是????
Clickhouse风格的语法: