mysql查询最近三个月数据方法

select * from t_user where time > DATE_SUB(CURDATE(), INTERVAL 1 WEEK)        --最近一周
select * from t_user where time > DATE_SUB(CURDATE(), INTERVAL 3 MONTH)       --最近三月
select * from t_user where time > DATE_SUB(CURDATE(), INTERVAL 1 YEAR)        --最近一年

select * from t_user where time <= DATE_SUB(CURDATE(), INTERVAL 1 WEEK)        --一周前
select * from t_user where time <= DATE_SUB(CURDATE(), INTERVAL 3 MONTH)       --三月前
select * from t_user where time <= DATE_SUB(CURDATE(), INTERVAL 1 YEAR)        --一年前