cjl
2023-09-12 ea1373d4e1511b620bb87872e692643e2edb81f8
fix:升级语句优化
1 files modified
2 ■■■ changed files
screen-api/src/main/resources/mapper/CityAqiDailyMapper.xml 2 ●●● patch | view | raw | blame | history
screen-api/src/main/resources/mapper/CityAqiDailyMapper.xml
@@ -23,7 +23,7 @@
            GROUP BY c.city_code order by nums
        </if>
        <if test="type == 3 ">
            and c.time <![CDATA[>=]]> #{start}
            and DATE_FORMAT(c.time,'%Y') <![CDATA[>=]]> #{start}
            GROUP BY c.city_code order by nums
        </if>
    </select>