mysql计算注册用户同比环比

数据运维 2023-08-05 醒在深海的猫 手机阅读

MySQL是一种流行的关系型数据库管理系统，它可以用来统计并计算注册用户的同比环比。下面，我们将介绍如何使用MySQL来完成这个任务。

-- 计算同比 SELECT COUNT(*) AS current_count, (SELECT COUNT(*) FROM users WHERE YEAR(created_at) = YEAR(NOW())-1) AS last_count, ROUND(COUNT(*)/(SELECT COUNT(*) FROM users WHERE YEAR(created_at) = YEAR(NOW())-1)*100,2) AS rate FROM users WHERE YEAR(created_at) = YEAR(NOW());