-
Notifications
You must be signed in to change notification settings - Fork 7
With
CoderDream edited this page Mar 18, 2022
·
2 revisions
WITH data1(id,parentid) AS ( select 2 id,1 parentid union select 3 id,1 parentid union select 4 id,1 parentid union select 5 id,2 parentid union select 6 id,5 parentid union select 7 id,6 parentid union select 1 id,0 parentid ) SELECT * FROM data1 ORDER BY id;