如何在MySQL中选择非连续行? [英] How to select non-consecutive rows in MySQL?

问题描述

如果记录的主键是1,3,4,5,6,8

我要选择带有pk的记录:1,6

I want to select the records with pk:1,6

注意

我不知道哪些ID是不连续的

I don't know which ids are non-consecutive

推荐答案

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

这篇关于如何在MySQL中选择非连续行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！