All pastes #145251 Raw Edit

Mine

public text v1 · immutable
#145251 ·published 2006-08-22 21:47 UTC
rendered paste body
SELECT a.bar+1 AS 'Missing From', MIN(b.bar) - 1 AS 'To' FROM foo AS a, foo AS b WHERE a.bar < b.bar GROUP BY a.bar HAVING 'Missing From' < MIN(b.bar) - 1 ORDER BY 1;
+--------------+------+
| Missing From | To   |
+--------------+------+
|            2 |    1 |
|            3 |    3 |
+--------------+------+