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

SO 58174638 - Gaps and islands bundled by non-null values

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 9, rows affected: 9, absolute service time: 0,26 sec, absolute service time: 0,26 sec 
edit mode |  history 
  
transaction_date
transaction_sale
count



1
01.10.2018 00:00:00
NULL
NULL



2
01.11.2018 00:00:00
33
1



3
01.12.2018 00:00:00
NULL
NULL



4
01.01.2019 00:00:00
NULL
NULL



5
01.02.2019 00:00:00
NULL
NULL



6
01.03.2019 00:00:00
2
3



7
01.04.2019 00:00:00
NULL
NULL



8
01.05.2019 00:00:00
NULL
NULL



9
01.06.2019 00:00:00
10
2






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development