怎么过滤掉最近或上一月26日之后的数据,
SELECT
*
FROM
tabname
WHERE
RT <= CASE
WHEN DATE_FORMAT(CURDATE(), "%d") > 26 THEN
DATE_FORMAT(CURDATE(), "%Y-%m-26")
ELSE
DATE_FORMAT(
DATE_SUB(CURDATE(), INTERVAL 1 MONTH),
"%Y-%m-26"
)
END
——————————————————————————————————
where 日期<concat((select left(max(日期),7) from table),'-26')