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 vote328 views1 answer
How to reset the database value in SQL server
SQL
0 vote335 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
6 votes326 views2 answers
Psql load dump
SQL
0 vote366 views1 answer
Dockerfile example for Django
SQL
0 vote315 views1 answer
Mysql update set sum
SQL
1 vote318 views2 answers
Oracle 18c xe ORA-65096
SQL
7 votes306 views2 answers
N highest salary in sql
SQL
5 votes323 views6 answers
Sql foreign key
SQL
1 vote317 views1 answer
Too many connections mysql
SQL
0 vote335 views1 answer
Running percentage of total postgres
SQL