select * from tb_prise SUM(CASE WHEN year = DATE_FORMAT(NOW(), ‘%Y’) THEN totalprice ELSE 0 END) AS yeartotalprice；
回答 0
暂无回答
doubleQ
select
sum(CASE WHEN (DATE_FORMAT(“year”, ‘%Y’) = DATE_FORMAT(NOW(), ‘%Y’)
) THEN DATE_FORMAT(“year”, ‘%Y’) ELSE 0 END) as yeartotalprice
from
tb_prise ;
select
sum(CASE WHEN (DATE_FORMAT(“year”, ‘%Y’) = DATE_FORMAT(NOW(), ‘%Y’)
) THEN DATE_FORMAT(“year”, ‘%Y’) ELSE 0 END) as yeartotalprice
from
tb_prise ;
需注意year是关键字