u012881002的专栏

原创 数据库查询近七天的数据

SELECT * FROM agentclass WHERE platformid = 1 AND unionname = '联盟1' AND levelname = '级别1' AND DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(intime) AND intime < CURRENT_DATE () GROUP BY intime;