如何有条件的查询表数据 if else
select sum(case when a=0 then cost else 0 end) as mem1,sum(case when a=1 then cost else 0 end) as mem2 from dayjsmx group by a
或者
select aa.mem as mem1,bb.mem as mem2 from
(select sum(cost) as mem from dayjsmx where a=1 ) aa
(select sum(cost) as mem from dayjsmx where a=0 )bb
或者
select mem1=(select sum(cost) as mem from dayjsmx where a=1 ),
mem2=(select sum(cost) as mem from dayjsmx where a=0)
按回答时间 | 按评价高低网友回答(共1个回答)
最新影片列表：
1
|
