SELECT MAX(CAST(value AS DECIMAL(10,2))) AS max_value FROM ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('-2.79,-2.63,-1.96,-0.54,-0.44,-0.68,-0.62,-1.30,-1.49', ',', numbers.n), ',', -1) AS value FROM ( SELECT @rownum := @rownum + 1 AS n FROM (SELECT @rownum:=0) t CROSS JOIN (SELECT 1 AS dummy UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) T1 CROSS JOIN (SELECT 1 AS dummy UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) T2 ) numbers WHERE CHAR_LENGTH('-2.79,-2.63,-1.96,-0.54,-0.44,-0.68,-0.62,-1.30,-1.49') - CHAR_LENGTH(REPLACE('-2.79,-2.63,-1.96,-0.54,-0.44,-0.68,-0.62,-1.30,-1.49', ',', '')) >= numbers.n - 1 ) t;

一个数组字符串-279-263-196-054-044-068-062-130-149以分割要求:获取最大值用mysql 写代码

原文地址: https://www.cveoy.top/t/topic/bXY9 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录