假设表名叫record,并且有一个字段名为NO,数据类型必须是整数或是字符串。
SELECT *, (endNO-startNO) AS diff FROM (
SELECT startNO, (SELECT MIN(NO)-1 FROM record WHERE NO>startNO) AS endNO
FROM (
SELECT NO+1 AS startNO FROM record
WHERE
NO+1 NOT IN (SELECT NO FROM record)
AND NO <(SELECT MAX(NO) FROM record)
) AS maxnum
) AS consistency