sql 获取最近7天的数据

1、获取最近7天的数据

SELECT * FROM "表名"
WHERE 
DATE_SUB( CURDATE( ), INTERVAL 7 DAY ) <= date( "时间列名") ) 

2、获取最近7天的数据并且按照天来分组

SELECT
DATE_FORMAT( "时间列名", '%Y-%m-%d' ) days,
count(*) count 
FROM

( SELECT * FROM "表名"
WHERE DATE_SUB( CURDATE( ), INTERVAL 7 DAY ) <= date( "时间列名") ) as "表别名"

GROUP BY
days;