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

8 votes187 views1 answer
Mysql limit rows
SQL
0 vote180 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
3 votes236 views2 answers
Find string in stored procedure sql server
SQL
7 votes175 views3 answers
How to check table name in current database sql
SQL
0 vote266 views1 answer
ORA-01400
SQL
0 vote232 views1 answer
Start stop mysql linux
SQL
0 vote196 views1 answer
Createdb with postgresql on ubuntu
SQL
9 votes215 views1 answer
Identity insert on sql server
SQL
0 vote191 views2 answers
Which MySQL statement is used to delete data from a database
SQL
20 votes190 views6 answers
Change password in mysql
SQL