连续2/3/4/5/6/7/8天推送同一种异常数据的sql代码咋写

连续2天推送同一种异常数据的SQL代码：

SELECT * FROM table_name 
WHERE date_column BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND CURDATE() 
AND exception_column = 'your_exception';

连续3天推送同一种异常数据的SQL代码：

SELECT * FROM table_name 
WHERE date_column BETWEEN DATE_SUB(CURDATE(), INTERVAL 2 DAY) AND CURDATE() 
AND exception_column = 'your_exception' 
GROUP BY date_column 
HAVING COUNT(*) = 3;

连续4天推送同一种异常数据的SQL代码：

SELECT * FROM table_name 
WHERE date_column BETWEEN DATE_SUB(CURDATE(), INTERVAL 3 DAY) AND CURDATE() 
AND exception_column = 'your_exception' 
GROUP BY date_column 
HAVING COUNT(*) = 4;

连续5天推送同一种异常数据的SQL代码：

SELECT * FROM table_name 
WHERE date_column BETWEEN DATE_SUB(CURDATE(), INTERVAL 4 DAY) AND CURDATE() 
AND exception_column = 'your_exception' 
GROUP BY date_column 
HAVING COUNT(*) = 5;

连续6天推送同一种异常数据的SQL代码：

SELECT * FROM table_name 
WHERE date_column BETWEEN DATE_SUB(CURDATE(), INTERVAL 5 DAY) AND CURDATE() 
AND exception_column = 'your_exception' 
GROUP BY date_column 
HAVING COUNT(*) = 6;

连续7天推送同一种异常数据的SQL代码：

SELECT * FROM table_name 
WHERE date_column BETWEEN DATE_SUB(CURDATE(), INTERVAL 6 DAY) AND CURDATE() 
AND exception_column = 'your_exception' 
GROUP BY date_column 
HAVING COUNT(*) = 7;

连续8天推送同一种异常数据的SQL代码：

SELECT * FROM table_name 
WHERE date_column BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE() 
AND exception_column = 'your_exception' 
GROUP BY date_column 
HAVING COUNT(*) = 8;

其中，table_name是你需要查询的表名，date_column是包含日期信息的列名，exception_column是异常数据的列名，your_exception是你需要查询的异常数据的值。