101-mysql left join 一对多，取右表最新一条记录

IT行业相对于一般传统行业，发展更新速度更快，一旦停止了学习，很快就会被行业所淘汰。所以我们需要踏踏实实的不断学习，精进自己的技术，尤其是初学者。今天golang学习网给大家整理了《101-mysql left join 一对多，取右表最新一条记录》，聊聊MySQL，我们一起来看看吧！

        SELECT
            a.*,
            e.userName as chatUser,
            e.content as content,
            e.chatTime as chatTime
        FROM
            gp_group AS a
        LEFT JOIN (
            SELECT b.* FROM chat_content b
            LEFT JOIN (
                SELECT MAX(c.id) AS id, c.groupUnid FROM chat_content c GROUP BY c.groupUnid
            ) AS d ON d.groupUnid = b.groupUnid
        WHERE b.id = d.id
        ) AS e ON a.id = e.groupUnid
        where 1=1
        
            and a.status = #{qo.status}
        
        order by e.chatTime desc

以上就是《101-mysql left join 一对多，取右表最新一条记录》的详细内容，更多关于mysql的资料请关注golang学习网公众号！