mysql - SQL 递归 desc select

Question

我在 mariaDB 中有以下 SQL 递归

with recursive supervisor as (
select * from staff where staff_id=6
union
select s.* from staff as s, supervisor as su
where s.staff_id=su.supervisor_id
)
select * from supervisor;

这是执行结果

如何将顺序更改为降序。

Answer 1

添加一个ROWNUM，然后在外部SELECT上添加ORDER BY ROWNUM DESC。