Sql gap missing values

SELECT * FROM (
  SELECT x, (SELECT min(x) FROM my_table t2 WHERE t2.x > t.x) next_x
  FROM my_table t
) WHERE x <> next_x - 1;
/* if my_table contains for x:  1 2 5 6 7 10
    X		NEXT_X
    2		5
    7		10
*/
-- ⇓ Test it ⇓ (Fiddle source link)

Source: sqlfiddle.com

Similar codes

0 vote114 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
1 vote113 views1 answer
Mysql login console
SQL
3 votes138 views2 answers
Synonym oracle
SQL
1 vote113 views1 answer
Mysql view command
SQL
0 vote110 views2 answers
Mysql unique two columns
SQL
0 vote114 views1 answer
Mysql add to value
SQL
6 votes120 views1 answer
Postgresql add enum value
SQL
0 vote114 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote124 views1 answer
Migration graphql
SQL
8 votes143 views1 answer
Mysql dump restore
SQL