摘要:
@Select("SELECT IFNULL(SUM(${val}),0) cnt FROM table WHERE DATE_FORMAT(IF (m < 10,CONCAT(y,'-0',m,'-01'),CONCAT(y,'-',m,'-01')),'%Y-%m-%d') BETWEEN ${ 阅读全文
摘要:
SELECT year_month_val, xun, flux, ROUND(@temp:=@temp+flux,4) AS yearVal FROM (SELECT year_month_val, xun, SUM(flux)flux FROM wrs_muw_plan WHERE manage 阅读全文