mysql 实现序号化数字中缺失的数字

最新推荐文章于 2022-10-08 10:41:27 发布

IT的鱼

最新推荐文章于 2022-10-08 10:41:27 发布

阅读量740

点赞数

分类专栏： oracle Mysql 文章标签： mysql 数据库 database

本文链接：https://blog.csdn.net/qq_32521313/article/details/123380346

版权

oracle 同时被 2 个专栏收录

15 篇文章 0 订阅

订阅专栏

Mysql

14 篇文章 0 订阅

订阅专栏

SELECT
	( SELECT IFNULL(max(CAST( commodity_number AS SIGNED )),0) + 1 FROM ( SELECT commodity_number FROM sys_commodity WHERE company_id = '950872849940217856' ) AS b   WHERE commodity_number < a.commodity_number ) AS sort
FROM
	( SELECT commodity_number FROM sys_commodity WHERE company_id = '950872849940217856' ) AS a 
WHERE
	a.commodity_number > ( SELECT IFNULL(max(CAST( commodity_number AS SIGNED )),0)+ 1 FROM ( SELECT commodity_number FROM sys_commodity WHERE company_id = '950872849940217856' ) AS b WHERE commodity_number < a.commodity_number ) 
ORDER BY
	commodity_number ASC;