每周一统计上周一到周日的数据,每周二统计周一的数据,
每周三,四,五,六,日分别统计,
每周一到每周二,三,四,五,六的数据。日期的sql如下:
SELECT CASE
WHEN DAYOFWEEK(CURRENT DATE) - 1 <= 1 THEN CURRENT DATE - (DAYOFWEEK(CURRENT DATE) + 5) DAY
ELSE CURRENT DATE - (DAYOFWEEK(CURRENT DATE) - 2) DAY END BEGIN_DATE,
CURRENT DATE - 1 DAY END_DATE
FROM SYSIBM.dual;
2019-05-27 效果如下: