—— 阿尔伯特·爱因斯坦

程序员の奇妙冒险

常用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_days
FROM your_table
WHERE object_id = 'your_object_id'
GROUP BY object_id
 
评论(0)
暂无评论来抢沙发吧~