mysql - 同一张表上的多个 order by

Question

假设我有 3 个简单的选择:

select * from `table` order by `id` desc limit 10

select * from `table` order by `date` desc limit 10

select * from `table` order by `name` desc limit 10

是否可以将这三个查询合并到一个查询中？

谢谢

Answer 1

您可以使用union all:

(select * from `table` order by `id` desc limit 10)
union all
(select * from `table` order by `date` desc limit 10)
union all
(select * from `table` order by `name` desc limit 10);