分组后按user_id 取时间最近的那一条 。 php思路也行。

Question

SELECT
    a.id,
    a.order_type,
    a.user_id,
    GROUP_CONCAT(b.star_id) AS starIdStr,
    GROUP_CONCAT(c.weibo_user_id) AS weiboIdStr,
    sum(order_amount) AS sumPrice,
  a.order_time
FROM
    tb_order_info AS a
INNER JOIN tb_order_star AS b
INNER JOIN tb_star AS c
WHERE
    (
        a.id = b.order_id
        AND b.star_id = c.id
    )
group by a.id
order by  a.order_time desc

![clipboard.png](/img/bVYT72)

分组后按user_id 取时间最近的那一条 。
怎么取 求大神 ，php思路也行。

Answer 1

https://segmentfault.com/q/10...

Answer 2

https://www.olcms.com/2048

Answer 3

select id,max(time) from 表 group BY id

Answer 4

用MIN函数即可

select min(order_time),id,order_type,user_id,starIdStr,weiboIdStr,sumPrice from tb_order_info group by user_id