SELECT
ID,
ACCOUNT_ID,
PLAN_NAME,
PLAN_ICON,
PLAN_TYPE,
TYPE_PIC,
PUNCH_UNIT,
PUNCH_UNIT_DAY,
PUNCH_UNIT_REQUIREMENT,
PUNCH_PRIOD,
INSIST_CYCLE,
REWARD_TYPE,
REWARD_NUM,
PARENT_REWARD,
WECHAT_REMIND_CYCLE,
START_DATE,
LAST_DATE,
IS_PREVIOUS_PERIOD,
IS_DELETE,
REMARK,
EXTEND_FIELD,
IS_COMPLETE
FROM
FA_EDUCATION_USER_PLAN
WHERE
– START_DATE > EXTRACT( YEAR_MONTH FROM date_sub( curdate( ), INTERVAL 9 MONTH ) )
START_DATE > DATE_SUB(CURDATE(), INTERVAL 7 MONTH)
ORDER BY
id DESC
sql 近几个月的数据
最新推荐文章于 2024-04-25 10:54:37 发布