sql - MSSQL select count where condition is met across a ...

sql - MSSQL select count where condition is met across a ...

瀏覽:1173
日期:2025-11-15
2012年4月24日 - how about? SELECT [date] ,count(*) FROM Shifts as s WHERE s.Date > DATEADD(day,-7,GETDATE()) AND ShiftWorked = 'Night' GROUP BY date....看更多