当我尝试运行这个MySQL命令时,我得到了这个错误:AUTHOR VARCHAR_IGNORECASEError Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL
这是显示最新购买日期的片段。max(purchase_date) -1是我所需要的,两者并排显示.from orders(select id, max(purchase_date) as max_date group by id) o2
orders.purchase_date = o2.max_date