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

Get Min In time and Max out TIme. Fom Attendance record in Sql Server

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 2, rows affected: 7, absolute service time: 0,17 sec 
fork mode |  history 
  
EmpCode
wrk
InTime
OutTime
TotalTime



1
143
2017-02-13
08:09:02 PM
05:12:04 AM
10:38:00



2
143
2017-02-14
08:09:26 PM
05:08:13 AM
02:12:00






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development