复杂sql集锦 - 查询最近7日快过生日的用户 ```sql SELECT * FROM "table" WHERE DATE_FORMAT( birthday, "%m%d" ) BETWEEN DATE_FORMAT( DATE_SUB(NOW(),INTERVAL 7 DAY), '%m%d' ) AND DATE_FORMAT( DATE_ADD( now( ),INTERVAL 7 DAY), '%m%d' ) LIMIT 10 ``` - 查询七日数据统计，并按每天展示结果集 ```sql SELECT DATE_FORMAT( create_time, '%Y-%m-%d' ) days, sum( amount ) AS amount FROM ( SELECT * FROM "table" WHERE delete_time IS NULL AND DATE_SUB( CURDATE( ), INTERVAL 7 DAY ) <= date( create_time ) ) AS a GROUP BY days ```