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 vote239 views1 answer
Login failed for user sql server
SQL
2 votes259 views1 answer
Create mysql user on all hosts
SQL
0 vote234 views1 answer
Equi joins in oracle
SQL
-1 vote234 views1 answer
Condition in orderby mysql
SQL
0 vote236 views1 answer
How to find sql server name
SQL
1 vote221 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote226 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote251 views1 answer
WHERE not regex in SQL
SQL
0 vote196 views1 answer
Oracle sysdba connect as another user
SQL
0 vote234 views1 answer
How to write triggers to increment or decrement the number of employees
SQL