示例 SELECT COALESCE ( SUM( scale ), 0 ) FROM bq_fund_achievement WHERE sale_time LIKE CONCAT(#{date},'%'); SELECT COALESCE ( SUM( scale ), 0 ) FROM bq_fund_achievement WHERE sale_time BETWEEN #{startDate} AND #{endDate}; 分类: MyBatis 毛巳煜 高级软件开发全栈架构师