SQL筛选连续三天的日期
-
sql筛选连续三天的日期
要筛选连续三天的日期,可以使用以下SQL语句:,,``sql,SELECT t1.date, t2.date, t3.date,FROM table_name t1, table_name t2, table_name t3,WHERE t1.date = DATE_SUB(t2.date, INTERVAL 1 DAY),AND t2.date = DATE_SUB(t3.date, INTERVAL 1 DAY),AND t1.date ˃= CURDATE() - INTERVAL 3 DAY;,``