SELECT BigCategory,SmallCategory,Model_No,1 'yuefen',SUM(case when BizType='P' then MONTH1Num end ) as P,SUM(case when BizType='S' then MONTH1Num end ) as S,SUM(case when BizType='I' then MONTH1Num end ) as I,SUM(case when BizType='P' then MONTH1Num end )- SUM(case when BizType='S' then MONTH1Num end )-SUM(case when BizType='I' then MONTH1Num end ) PanDianFROM t_testWHERE Model_No like 'iphone4s%'OR WHERE Model_No like 'v480%'SELECT BigCategory,SmallCategory,Model_No,1 'yuefen',SUM(case when BizType='P' then MONTH1Num end ) as P,SUM(case when BizType='S' then MONTH1Num end ) as S,SUM(case when BizType='I' then MONTH1Num end ) as I,SUM(case when BizType='P' then MONTH1Num end )- SUM(case when BizType='S' then MONTH1Num end )-SUM(case when BizType='I' then MONTH1Num end ) PanDianFROM t_testWHERE Model_No like 'iphone4s%'OR WHERE Model_No like 'v480%'GROUP BY BigCategory,SmallCategory,Model_No;我這段代碼為什么老是報錯，用的是mysql數據庫
2 回答
紅糖糍粑
TA貢獻1815條經驗 獲得超6個贊
你的代碼 有兩個 where
WHERE Model_No like 'iphone4s%'
OR WHERE Model_No like 'v480%'
改成這樣
WHERE Model_No like 'iphone4s%'
OR Model_No like 'v480%'
幕布斯7119047
TA貢獻1794條經驗 獲得超8個贊
select * from mm where name like '王%' or name like '張%' or name like '李%'
或者
select name from table where name like '王%'
union
select name from table where name like '張%'
union
select name from table where name like '李%'
添加回答
舉報
0/150
提交
取消