sql 判断连续数字

最新推荐文章于 2024-05-10 17:42:31 发布

weixin_34037173

最新推荐文章于 2024-05-10 17:42:31 发布

阅读量2.6k

点赞数

文章标签： python 数据库

原文链接：https://my.oschina.net/u/3238650/blog/2236984

版权

2019独角兽企业重金招聘Python工程师标准>>>

设表名为TABLENAME,字段名为FIELD1则：
SELECT
	FIELDN = FIELD1 
FROM
	TABLENAME 
WHERE
	NOT EXISTS (
SELECT
	FIELD1 
FROM
	TABLENAME A 
WHERE
	A.FIELD1 = tablename.field1 + 1 
	) UNION
SELECT
	FIELDN = FIELD1 
FROM
	TABLENAME 
WHERE
	NOT EXISTS (
SELECT
	FIELD1 
FROM
	TABLENAME A 
WHERE
	A.FIELD1 + 1 = tablename.field1 
	) 
ORDER BY
	FIELDN

转载于:https://my.oschina.net/u/3238650/blog/2236984