常用SQL笔记MySQL
2025-04-08 23:59阅读:51评论:0
MySQL之统计某个对象分别在30天内、30天到60天的金额
SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
SELECT object_id, SUM(CASE WHEN date_column >= CURDATE() - INTERVAL 30 DAY AND date_column < CURDATE() THEN amount ELSE 0 END) AS amount_30_days, SUM(CASE WHEN date_column >= CURDATE() - INTERVAL 60 DAY AND date_column < CURDATE() - INTERVAL 30 DAY THEN amount ELSE 0 END) AS amount_30_to_60_daysFROM your_tableWHERE object_id = 'your_object_id'GROUP BY object_id