mysql查询过去一周数据

mysql查询过去一周数据

表名 quality ,字段名 QualityInfo_time ，类型：datetime

-- 过去一周所有数据
select * from quality where week(QualityInfo_time) = week(SYSDATE());

select * from quality where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(QualityInfo_time);

-- 查询最近7天的数据：
-- 1.以当天为起点
SELECT * FROM quality e where DATE_SUB(CURDATE(), INTERVAL 6 DAY) <= date(QualityInfo_time)

-- 2.以数据库最新的时间最为最近的一天
SELECT * FROM quality e where QualityInfo_time > DATE_ADD((select QualityInfo_time from quality ORDER BY QualityInfo_time DESC limit 1) ,INTERVAL -7 day) and (select QualityInfo_time from quality ORDER BY QualityInfo_time DESC limit 1) >= QualityInfo_time


-- 当天所有数据
select * from quality where to_days(QualityInfo_time) = to_days(now());
select * from quality where date(QualityInfo_time) = curdate();

-- 过去一月所有数据
select * from quality where DATE_SUB(CURDATE(),INTERVAL 1 MONTH) <=date(QualityInfo_time);

-- 过去一年所有数据
select * from quality  where DATE_SUB(CURDATE(), INTERVAL 1 YEAR) <= date(QualityInfo_time);


-- sql查询表中的重复数据

select * from quality where QualityInfo_time in (select QualityInfo_time from quality group by QualityInfo_time HAVING COUNT(*) > 1) order by QualityInfo_time