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

SQL Server Select the most recent past date if no future date availab

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 7, rows affected: 7, absolute service time: 0,17 sec 
fork mode |  history 
  
CustId
OrderDate
rownum



1
1
2019-09-01
1



2
1
2016-11-01
2



3
2
2019-07-01
1



4
2
2019-11-01
2



5
3
2017-01-01
1



6
4
2017-01-01
1



7
4
2016-12-01
2






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development