Re: sql 行转列

[Jark Wu]

Hi

如果我理解的没错，agg with filter 语法能满足你的需求。

select ip,
  sum(t) filter (where status = 'success')
  sum(t) filter (where status = 'fail')
from view1
group by ip

Best,
Jark

On Sun, 26 Apr 2020 at 20:56, Leonard Xu <xbjt...@gmail.com> wrote:

> Hi，
>
> > select ip,
> > case status when 'success' THEN sum(t) ELSE 0 end successct,
> > case status when 'fail' THEN sum(t) ELSE 0 end failct
> > from view1
> > group by ip
>
> 这个 sql 应该ok的，看讨论也可以满足你的需求，是有报错吗？麻烦贴下报错和 view1的大致逻辑
>
> Best,
> Leonard Xu