MySQL按表中某字段分组然后按照固定顺序取第一条

七对dolce

于 2019-01-24 20:21:41 发布

阅读量3.2k

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/qq_38431305/article/details/86632659

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

select ip, created_at, customer_id from (select * from customer_activity_log where op_code = 2000 GROUP BY customer_id ,created_at desc) as base group by customer_id

七对dolce

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
4
评论
MySQL按表中某字段分组然后按照固定顺序取第一条

select ip, created_at, customer_id from (select * from customer_activity_log where op_code = 2000 GROUP BY customer_id ,created_at desc) as base group by customer_id
复制链接

扫一扫

专栏目录