<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.njcn.mapper.excelreport.PercentMapper">
    <select id="getFpy" resultType="com.njcn.pojo.data.LimitRate">
        SELECT
        SUM(UHARM_2_OVERTIME) UHARM2OVERTIME,SUM(IHARM_2_OVERTIME) IHARM2OVERTIME,
        SUM(UHARM_3_OVERTIME) UHARM3OVERTIME,SUM(IHARM_3_OVERTIME) IHARM3OVERTIME,
        SUM(UHARM_4_OVERTIME) UHARM4OVERTIME,SUM(IHARM_4_OVERTIME) IHARM4OVERTIME,
        SUM(UHARM_5_OVERTIME) UHARM5OVERTIME,SUM(IHARM_5_OVERTIME) IHARM5OVERTIME,
        SUM(UHARM_6_OVERTIME) UHARM6OVERTIME,SUM(IHARM_6_OVERTIME) IHARM6OVERTIME,
        SUM(UHARM_7_OVERTIME) UHARM7OVERTIME,SUM(IHARM_7_OVERTIME) IHARM7OVERTIME,
        SUM(UHARM_8_OVERTIME) UHARM8OVERTIME,SUM(IHARM_8_OVERTIME) IHARM8OVERTIME,
        SUM(UHARM_9_OVERTIME) UHARM9OVERTIME,SUM(IHARM_9_OVERTIME) IHARM9OVERTIME,
        SUM(UHARM_10_OVERTIME) UHARM10OVERTIME,SUM(IHARM_10_OVERTIME) IHARM10OVERTIME,
        SUM(UHARM_11_OVERTIME) UHARM11OVERTIME,SUM(IHARM_11_OVERTIME) IHARM11OVERTIME,
        SUM(UHARM_12_OVERTIME) UHARM12OVERTIME,SUM(IHARM_12_OVERTIME) IHARM12OVERTIME,
        SUM(UHARM_13_OVERTIME) UHARM13OVERTIME,SUM(IHARM_13_OVERTIME) IHARM13OVERTIME,
        SUM(UHARM_14_OVERTIME) UHARM14OVERTIME,SUM(IHARM_14_OVERTIME) IHARM14OVERTIME,
        SUM(UHARM_15_OVERTIME) UHARM15OVERTIME,SUM(IHARM_15_OVERTIME) IHARM15OVERTIME,
        SUM(UHARM_16_OVERTIME) UHARM16OVERTIME,SUM(IHARM_16_OVERTIME) IHARM16OVERTIME,
        SUM(UHARM_17_OVERTIME) UHARM17OVERTIME,SUM(IHARM_17_OVERTIME) IHARM17OVERTIME,
        SUM(UHARM_18_OVERTIME) UHARM18OVERTIME,SUM(IHARM_18_OVERTIME) IHARM18OVERTIME,
        SUM(UHARM_19_OVERTIME) UHARM19OVERTIME,SUM(IHARM_19_OVERTIME) IHARM19OVERTIME,
        SUM(UHARM_20_OVERTIME) UHARM20OVERTIME,SUM(IHARM_20_OVERTIME) IHARM20OVERTIME,
        SUM(UHARM_21_OVERTIME) UHARM21OVERTIME,SUM(IHARM_21_OVERTIME) IHARM21OVERTIME,
        SUM(UHARM_22_OVERTIME) UHARM22OVERTIME,SUM(IHARM_22_OVERTIME) IHARM22OVERTIME,
        SUM(UHARM_23_OVERTIME) UHARM23OVERTIME,SUM(IHARM_23_OVERTIME) IHARM23OVERTIME,
        SUM(UHARM_24_OVERTIME) UHARM24OVERTIME,SUM(IHARM_24_OVERTIME) IHARM24OVERTIME,
        SUM(UHARM_25_OVERTIME) UHARM25OVERTIME,SUM(IHARM_25_OVERTIME) IHARM25OVERTIME,
        SUM(VOLTAGE_DEV_OVERTIME) VOLTAGEDEVOVERTIME,SUM(UABERRANCE_OVERTIME)
        UABERRANCEOVERTIME,SUM(FREQ_DEV_OVERTIME) FREQDEVOVERTIME,SUM(FLICKET_ALLTIME)
        FLICKETALLTIME,SUM(UBALANCE_OVERTIME) UBALANCEOVERTIME,SUM(ALLTIME) ALLTIME,SUM(FLICKER_OVERTIME) FLICKEROVERTIME FROM LIMIT_RATE
        where timeid between #{start} and #{end} and myindex = #{pointIndex} and
        Phasic_Type = 'T'
    </select>
</mapper>