当前位置：网站首页>SQLserver adds a judgment

SQLserver adds a judgment

2022-08-10 02:52:00 【CSDN q&a】

SELECT count(distinct lp.lot_number)as ELzs
FROM (SELECT lp.lot_number,lp.TransDate,lp.WorkorderId ,lp.device_number,
ROW_NUMBER() OVER( PARTITION BY lp.lot_number ORDER BYlp.TransDate)RN FROM Lot_Process lp)lp
WHERE RN=2 and (lp.WorkorderId like 'PB%' or lp.WorkorderId like 'DB%') and
lp.device_number in('M1-EL1-L1-01','M1-EL1-L1-02')
and lp.TransDate between convert(varchar(11),dateadd(day,-1,getdate()),120)+'08:00:00'
and convert(varchar(11),dateadd(day,-1,getdate()),120)+'19:59:59'

Add a judgment to help. Before 9 o'clock every day, check yesterday's 8:00 to yesterday's 20:00, and after 9:00, check today's 8:00 to today's 20:00.

原网站

版权声明
本文为[CSDN q&a]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/222/202208031034453825.html