Heim > Fragen und Antworten > Hauptteil
So verwenden Sie diese Fallbedingung in der Clickhouse-Datenbank, um die Ausgabe in %-Form anzuzeigen.
ROUND(count(distinct case when bt.status = 'approved' then bt.id else null end)/count(distinct p.id) * 100) as "SR- txns"
P粉7544734682023-09-15 10:06:02
但它按原样工作???
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 │
└──────────┘