56,677
社区成员
发帖
与我相关
我的任务
分享
-- SELECT GROUP_CONCAT(info SEPARATOR '\n') FROM( -- 如果是拼成一个字符串
SELECT info FROM(
SELECT time, sort, time as info
FROM(
SELECT DATE_FORMAT(time, '%Y-%m-%d') as time, MAX(sort) + 1 as sort
FROM tb GROUP BY time
) a
UNION ALL
SELECT DATE_FORMAT(time, '%Y-%m-%d') as time, sort, info
) DATA ORDER BY TIME DESC, sort DESC