SELECT * FROM t_download WHERE user_id = 1 ORDER BY created_time DESC
SELECT *
FROM (
SELECT * FROM t_download WHERE user_id = 1 ORDER BY created_time DESC
) AS subquery GROUP BY item_id;
直接这样也不行
vf
SELECT * FROM t_download WHERE user_id = 1 GROUP BY item_id ORDER BY created_time DESC
想要的结果就是图一那个排序再 GROUP BY item_id
之后应该是 1330,3995 ...
要怎么做
通义灵码找到答案,需要这么复杂吗?