月报统计:根据数据库表字段并按月查询某列的总和(sum)

加载中...

根据score_key并按month查询某列的总和(sum)

<select id="getSumScoresMonth" resultType="Integer">

  select sum(score_value)

  from score_user_detail

  where up_id = #{upId}

  and score_type = 1

  and user_id = #{userId}

  <if test="msgKey!=null">

  and score_key in ('studyScores','readScores')

  </if>

  and DATE_FORMAT(create_time, '%Y-%m') = #{stMonth}

</select>