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 vote187 views1 answer
Can we rollback deleted data in sql
SQL
2 votes189 views1 answer
Import large .sql files into lampp
SQL
0 vote200 views1 answer
Create a sql server database programmatically
SQL
0 vote199 views1 answer
Oracle current timestamp
SQL
3 votes189 views3 answers
Stop mysql ubuntu
SQL
27 votes198 views4 answers
Get all tables with column name sql
SQL
0 vote197 views1 answer
Tsql cmd exec script from file
SQL
0 vote191 views1 answer
User defined variables in sql
SQL
9 votes202 views2 answers
Sql server check table exists
SQL
0 vote190 views1 answer
Get the First and Last Word from a String or Sentence
SQL