select 酒菜编号,sum(case 点单类型 when '点单' then 数量 else 0 end) as 点单数量,sum(case 点单类型 when '退单' then 数量 else 0 end) as 退单数量,sum(数量) as 总数 from 表名 group by 酒菜编号
select 酒菜编号,sum(case 点单类型 when '点单' then 数量 else 0 end) as 点单数量,sum(case 点单类型 when '退单' then 数量 else 0 end) as 退单数量,sum(数量) as 总数 from 表名 group by 酒菜编号
Select 酒菜编号,Sum(Case 點單類型 WHen '點單' As 數量 Else 0 End)
as '點單數量',
Sum(Case 點單類型 WHen '退單' As 數量 Else 0 End) as '退單數量',
Sum(數量) as '總數' From
yourTable Group By 酒菜编号
Select 酒菜编号,Sum(Case 點單類型 WHen '點單' As 數量 Else 0 End)
as '點單數量',
Sum(Case 點單類型 WHen '點單' As 數量 Else 0 End) as '退單數量',
Sum(數量) as '總數' From
yourTable Group By 酒菜编号