-- 查询最新一条数据
SELECT * FROM apple ORDER BY id DESC LIMIT 1;
-- 今天 
select * from apple where to_days(data_time) = to_days(now()); 
-- 昨天 
select * from apple where to_days(NOW()) - TO_DAYS(data_time) <= 1;  
-- 近7天 
select * from apple where date_sub(CURDATE(),INTERVAL 7 DAY) <= DATE(data_time);  
-- 近30天 
SELECT * FROM apple where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(data_time);
-- 本月 
SELECT * FROM apple WHERE DATE_FORMAT( data_time, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' );
-- 上一月 
SELECT * FROM apple WHERE PERIOD_DIFF( date_format( now( ) , '%Y%m' ) , date_format( data_time, '%Y%m' ) ) =1; 
-- 查询本季度数据 
select * FROM apple where QUARTER(data_time)=QUARTER(now()); 
-- 查询上季度数据 
select * FROM apple where QUARTER(data_time)=QUARTER(DATE_SUB(now(),interval 1 QUARTER));  
-- 查询本年数据 
select * FROM apple where YEAR(data_time)=YEAR(NOW());