Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Recursive cte (common table expression)

Language: Layout:
View schema
Execution time: 0.02 sec, rows selected: 4, rows affected: 0, absolute service time: 0.7 sec 
edit mode |  history  | discussion
   ID First_name Last_name Title Birth_date Pilots_ID Path
1 1 John Smith First pilot 5/5/1965 12:00:00 AM NULL 000000000001
2 2 John Doe Second pilot 1/2/1970 12:00:00 AM 1 000000000001000000000002
3 3 William Lee Third pilot 3/27/1975 12:00:00 AM 2 000000000001000000000002000000000003
4 4 Steve Quick Fourth pilot 12/23/1980 12:00:00 AM 3 000000000001000000000002000000000003000000000004