SELECT DISTINCT rror.recyclebin_id AS recyclebinId, rdt.name AS recyclebinName, sur.phonenumber AS phone, sur.nick_name AS nickName FROM re_order ror INNER JOIN re_recyclebin_order rror ON rror.id = ror.recyclebin_order_id INNER JOIN re_digit_recyclebin rdt ON rdt.id = rror.recyclebin_id left join sys_user sur ON rdt.admin_id = sur.user_id WHERE ror.order_status = '50' AND order_user = #{userId} Order By ror.complete_time DESC 影响了顺序,帮我改一下
时间: 2024-02-15 09:28:49 浏览: 140
可以将 Order By 子句放在整个 SQL 语句的最后,如下所示:
SELECT DISTINCT
rror.recyclebin_id AS recyclebinId,
rdt.name AS recyclebinName,
sur.phonenumber AS phone,
sur.nick_name AS nickName
FROM
re_order ror
INNER JOIN re_recyclebin_order rror ON rror.id = ror.recyclebin_order_id
INNER JOIN re_digit_recyclebin rdt ON rdt.id = rror.recyclebin_id
LEFT JOIN sys_user sur ON rdt.admin_id = sur.user_id
WHERE
ror.order_status = '50'
AND order_user = #{userId}
ORDER BY
ror.complete_time DESC
阅读全文
相关推荐



















