记mybatis 联合查询报：this is incompatible with sql_mode=only_full_group_by

关注

原创最新推荐文章于 2026-03-11 01:44:29 发布 465 阅读 AI 写同款· GEO 优化 ›

MySQL错误-this is incompatible with sql_mode=only_full_group_by完美解决方案有时候，遇到数据库重复数据，需要将数据进行分组，并取出其中一条来展示，这时就需要用到group by语句。但是，如果mysql是高版本，当执行group by时，select的字段不属于group by的字段的话，sql语句就会报错。阅读详情

<resultMap type="VisitInfo" id="VisitInfoMap">
        <id property="visitId" column="visit_id"/>
        <result property="visitIp" column="visit_ip"/>
        <result property="channelNumber" column="channel_number"/>
        <result property="showState" column="show_state"/>
        <result property="visitRegion" column="visit_region"/>
        <result property="waiterName" column="waiter_name"/>
        <result property="visitDay" column="visit_day"/>
        <result property="visitTime" column="visit_time"/>
        <result property="channelName" column="channel_name"/>
    </resultMap>

<select id="queryVisitByTime" resultMap="VisitInfoMap">
        select ANY_VALUE(channel_name)as channel_name,count(*) as 'dayNum' from visitInfo  a LEFT JOIN channelInfo b on a.channel_number=b.channel_number
        where a.visit_day>=#{visitDay} and #{endTime}>= a.visit_day  GROUP BY a.channel_number
    </select>

收录于