如何在Spring Boot项目上禁用activiti自动部署(How to disable activiti auto deployment on Spring Boot project)

 使用交叉应用将你的想法应用于你的行，然后采取差异。 
 
 阅读更多关于适用这里或这里 
 
Select A_In.emp_reader_id as empId,A_In.Belongs_to,B.emp_name,A_In.DeviceSerialNumber,
            DT as EntryTime,x.OutTime, Datediff(HOUR,a_in.DT,x.Outtime) as DifferenceTime from trnevents a_in
    CROSS APPLY (select min(DT) as OutTime
             from   trnevents A_Out
             where  EVENTID like '0'
             and    A_Out.emp_reader_id = A_In.emp_reader_id
             and    A_Out.DT > A_In.DT and DATEDIFF(day,A_In.Dt,A_Out.DT)=0
    ) x

Use cross apply to apply your mindate to your rows, and then take the difference.
 
Read more about apply here or here
 
Select A_In.emp_reader_id as empId,A_In.Belongs_to,B.emp_name,A_In.DeviceSerialNumber,
            DT as EntryTime,x.OutTime, Datediff(HOUR,a_in.DT,x.Outtime) as DifferenceTime from trnevents a_in
    CROSS APPLY (select min(DT) as OutTime
             from   trnevents A_Out
             where  EVENTID like '0'
             and    A_Out.emp_reader_id = A_In.emp_reader_id
             and    A_Out.DT > A_In.DT and DATEDIFF(day,A_In.Dt,A_Out.DT)=0
    ) x