20240425每日后端面试题-sql编码技巧

最新推荐文章于 2024-10-06 06:56:01 发布

杨诚实

最新推荐文章于 2024-10-06 06:56:01 发布

阅读量126

点赞数 2

分类专栏：每日后端文章标签： sql

本文链接：https://blog.csdn.net/weixin_42678822/article/details/138205412

版权

每日后端专栏收录该内容

42 篇文章 2 订阅

订阅专栏

根据逗号分隔的字段，取最大值

UPDATE vm_warning_order_t_202212 warA,
(SELECT
	a.warning_order_id,
	substring_index( substring_index( a.confidence_level, ',', b.help_topic_id + 1 ), ',',- 1 ) confidence_level,
	max(
		substring_index( substring_index( a.confidence_level, ',', b.help_topic_id + 1 ), ',',- 1 )) real_confidence_level 
	FROM
		vm_warning_order_t_202212 a
		JOIN mysql.help_topic b ON b.help_topic_id < ( length( a.confidence_level ) - length( REPLACE ( a.confidence_level, ',', '' ))+ 1 ) 
WHERE a.confidence_level like '%,%'
group BY
	a.warning_order_id) warB set warA.confidence_level_max = warB.real_confidence_level WHERE
 warA.warning_order_id = warB.warning_order_id