MyBatis之使用SUM关键字求和

<select id="checkRetrievalData" resultType="comcbox.portal.manage.model.RetrievalInfo">
    SELECT
        SUM(scount) AS scount,time
    FROM retrieval_info
    WHERE
     keyword =#{keyword}
 AND retrieval_page =#{retrievalPage}
    GROUP BY time
</select>

SUM(scount) AS scount：之所以取别名是SUM(scount)是对字段的求和，而数据库字段是没有这个数字的，所以取别名来赋予值来对应数据库字段。哈哈哈哈哈哈