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 vote320 views1 answer
Psql initialization
SQL
5 votes294 views1 answer
Oracle create table comment
SQL
0 vote346 views1 answer
Sql alternative to max statement
SQL
0 vote265 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote326 views1 answer
Space not removing from column in sql
SQL
0 vote300 views1 answer
Max mysql
SQL
6 votes346 views2 answers
How to get last element sql
SQL
0 vote275 views1 answer
Power query datetime to date
SQL
3 votes293 views1 answer
Oracle list invalid password ORA-01017
SQL
4 votes280 views3 answers
Count with where
SQL