有条件地找出缺失数字的问题补充

SELECT a.id, a.编号, a.五位数字 AS 当前数, (SELECT Top 1 [五位数字] from 表1 where a.id>id ORDER BY id desc) AS Tem, IIf(IsNull(tem),"",tem) AS 上位数, TestNm(当前数,上位数) AS 不同的数字, a.对比数字, IIf([对比数字] Is Null,"没有对比数字",IIf(InStr([不同的数字],Right([对比数字],1))>0,"YES","NO")) AS 对比结果
FROM 表1 AS a
ORDER BY a.id;