每天只需要一次刷卡记录,员工重复刷卡的情况下取第一次刷卡记录,数据库表精确到时分秒,现在需要以 年月日来分组:
SELECT SITE, MIN(CARDNO) AS cardno, APPLICATION_ID, MIN(DATE) AS date, FIELD_VALUE, IS_ACTIVE
FROM dbo.SYSTEM_LOGWHERE (LEN(CARDNO) > 0)
GROUP BY CARDNO, CONVERT(varchar(10), DATE, 120), SITE, APPLICATION_ID, FIELD_VALUE, IS_ACTIVE