比如表中记录的id分别是1,2,4,5,6,8
id
1,2,4,5,6,8
那我希望选出的id是1,6
1,6
SELECT * FROM your_table AS a LEFT JOIN your_table AS b ON a.key_column = b.key_column - 1 WHERE b.key_column IS NULL
标签
查看
665 次