PG 迁移 Doris 语法问题

Viewed 33

在PG 中有这么一个语法 sum (xx) filter(where xxxx) 如下:

select  
sum(doris_sequence_version) filter(where  address= '济南' ) as aaa,
sum(doris_sequence_version) filter(where  address= '菏泽') as bbb
from test_a_001
where id >= 1

像这种语法,如果不使用 case when替换, Doris怎么能实现这种查询可以正常的替换 sum(xxx) filter (where)。

1 Answers