SQL查找不连续的数据

select * from 表 t where not exists (select 1 from 表 where Goods_ID=t.Goods_ID-1)

原文地址:https://www.cnblogs.com/zunzunQ/p/14190222.html