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 vote176 views1 answer
Mysqli last row
SQL
6 votes170 views3 answers
Date_trunc postgres
SQL
2 votes143 views1 answer
Drop table purge
SQL
2 votes180 views1 answer
Column names in oracle sql
SQL
1 vote168 views1 answer
Oracle create index if not exists
SQL
0 vote147 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
8 votes153 views2 answers
Replace string value in sql
SQL
0 vote196 views1 answer
Python mysql executemany
SQL
0 vote146 views1 answer
Mysql with
SQL
0 vote165 views1 answer
How to locate pg_hba.conf file
SQL