sql 查询 对于表的一列去重后取出前三列再查询
一开始我是这么查询的 但爆出 This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’
SELECT * FROM `order` WHERE `uuid` IN (SELECT `uuid` FROM `order` GROUP BY `uuid` DESC LIMIT 0,10)
经过查询资料后知道解决办法
SELECT * FROM `order` WHERE `uuid` IN (SELE
原创
2021-06-12 15:55:39 ·
254 阅读 ·
0 评论