按日期时间排序字段不起作用 - mysql

Question

我想为所有客户获取最后下订单和移动#的日期。这是我的查询。

 SELECT c.customer_id, c.mobile, COALESCE( MAX( o.order_datetime ) ,  '0000-00-00 00:00:00' ) AS last_order_date
 FROM table_orders AS o
 RIGHT JOIN table_customers AS c ON o.customer_id = c.customer_id
 GROUP BY c.customer_id
 ORDER BY DATE( o.order_datetime ) 

它工作正常。但是不按 asc 顺序给我数据o.order_datetime？

查询中的错误是什么？

Answer 1

试试这个

 ORDER BY DATE( o.order_datetime ) DESC