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

1 vote311 views2 answers
Delete auto increment mysql
SQL
0 vote328 views1 answer
Default column value in sql same as other column
SQL
0 vote341 views1 answer
Gcloud check sql
SQL
6 votes342 views4 answers
Sqlite drop table
SQL
1 vote349 views1 answer
How to delete a record from sqlite in android
SQL
0 vote368 views1 answer
Like sql for second letter of the family name
SQL
8 votes346 views1 answer
Alter tablespace add datafile autoextend
SQL
22 votes343 views4 answers
Show list of users in mysql
SQL
0 vote379 views1 answer
SQL Server date literal
SQL
1 vote364 views1 answer
Mysql show attributes of a table
SQL