求一SQL语句

[stephen0126]

我想在一个selecrt的语句里面有3个字段，合计fs,fs>0时，合计fs,fs<0时，合计fs,

[繁花尽流年]

select sum(fs) as fs_0, sum(case when fs>0 then fs else 0 end ) as fs_1, sum(case when fs<0 then fs else 0 end ) as fs_2 from table

[alex259]

莫不是，你连分组条件都不说一下，就想直接sum？