MYSQL如何取表中月日数据较昨天变化率最大的值及日期?

发布网友发布时间：2022-04-30 02:19

共2个回答

热心网友时间：2022-06-29 01:38

SELECT
a.uid,
a. DAY,
ABS((a. VALUE / b. VALUE - 1) * 100) AS ct
FROM
TABLE_test a,
TABLE_test b
WHERE
DATE_FORMAT(b. DAY, '%Y-%m-%d') = ADDDATE(a. DAY ,- 1)
AND b. MONTH = a. MONTH
AND a.uid = b.uid
ORDER BY
ct DESC
LIMIT 1

热心网友时间：2022-06-29 01:38

Nobody played the mandolin like my father

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com