分组统计-实现输出各活动下不同票型最低价

实现SQL

    <select id="getMyCollectList" resultType="com.lekai.anybussfun.openapi.dto.FunCollectResDto">
        SELECT any_fun_collect.id , any_fun_collect.object_type , any_fun.`status` ,
        any_fun_collect.object_id, any_fun.posters , any_fun.title , any_fun.tag ,
        any_fun.remarks , any_fun_sessions_tickit_detail.tickit_type ,
        min(any_fun_sessions_tickit_detail.price)
        FROM any_fun_collect JOIN any_fun
        ON any_fun_collect.object_id = any_fun.id
        JOIN any_fun_sessions_tickit_detail
        ON any_fun_collect.object_id = any_fun_sessions_tickit_detail.activity_id
        WHERE any_fun_collect.object_type = 1 and any_fun_collect.member_id = #{id}
        group by any_fun_sessions_tickit_detail.tickit_type , any_fun_sessions_tickit_detail.activity_id
    </select>

连表查询
1、实现最值查询需要进行分组
2、当分组具有细化时可以按照多个字段进行分组，字段使用逗号隔开
3、where 进行某些条件删选