Mapper文件:
<!--部门按天查询kpi -->
<select id="selectLtcByDay"resultType="com.dragon.mos.pojo.MosKpi">
select
kpi_value
from
moskpi
-- 查询条件:最后一次录入的日期,input_date为字段名称
<where>
kpi_name = #{kpiName} and bga_name = #{bgaName}
</where>
ORDER BY input_date desc limit 0,1
</select>