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 vote171 views1 answer
Using distinct and count together in sql
SQL
0 vote149 views1 answer
Ajouter une clé etrangere mysql
SQL
9 votes150 views6 answers
Sql add column with default value
SQL
1 vote150 views1 answer
Mysql last year
SQL
-1 vote155 views1 answer
Phinehas Psalm 106
SQL
-1 vote102 views1 answer
Oracle db list usernames
SQL
0 vote137 views1 answer
Complete date is 1 year or not sql server
SQL
7 votes162 views2 answers
How to create index mysql
SQL
0 vote142 views2 answers
Oracle create chain rule
SQL
23 votes152 views4 answers
How to uninstall postgresql in ubuntu
SQL