От: | Mr. None | http://mrnone.blogspot.com | |
Дата: | 18.10.10 10:46 | ||
Оценка: | 157 (7) |
SELECT n.number AS _beg, n.number + (N - 1) AS _end
FROM numbers n
WHERE (
SELECT count(1) FROM numbers
WHERE numbers.number Between n.number AND n.number + (N - 1)) = N;