SQL Recursion desc select

Question

I have the following SQL Recursion in mariaDB

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;

This is the execution result

How can i change the order into descending.

so the staffs highest supervisor comes. at the moment mac diver is the first in the result but he is the lowest staff member. — code1x1.de, Dec 05 '17 at 10:59
i just found a similar problem that tells me their is no solution exept adding an index maybe in the recursion block https://stackoverflow.com/questions/3779180/reverse-the-natural-order-of-a-mysql-table-without-order-by — code1x1.de, Dec 05 '17 at 11:22

score 1 · Accepted Answer · answered Dec 05 '17 at 18:10

1

Add a ROWNUM as you got through, then ORDER BY ROWNUM DESC on the outer SELECT.

answered Dec 05 '17 at 18:10

Rick James

122,779
10
116
195

SQL Recursion desc select

1 Answers1