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

Gaps and islands query

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 7, rows affected: 11, absolute service time: 0,19 sec 
edit mode |  history 
  
name
act
startt
endd



1
jimmy
sleep
1
3



2
jimmy
wake
4
10



3
jimmy
sleep
11
13



4
karen
wake
1
4



5
karen
sleep
5
7



6
karen
wake
8
14



7
karen
sleep
15
20






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development