Run Code  | API  | Code Wall  | 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






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development