<select id="checkRetrievalData" resultType="com.cncbox.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)是对字段的求和,而数据库字段是没有这个数字的,所以取别名来赋予值来对应数据库字段。哈哈哈哈哈哈