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

Transitive grouping with recursive sql

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 5, rows affected: 5, absolute service time: 0,19 sec  
edit mode |  history  | discussion
   ID FirstName LastName DateOfBirth BirthCountry GroupID
1 2 Jane Doe 08.02.1982 00:00:00 Grand 101
2 1 John Doe 01.01.1983 00:00:00 Grand 101
3 4 Kay Wayne 08.06.1976 00:00:00 Grand 101
4 3 Adam Wayne 01.01.1983 00:00:00 Grand 101
5 5 Matt Knox 01.01.1983 00:00:00 Hay 102

    
                
λ
.NET NoSQL database for rapid development