Re: ��� ��������� ��������� �������������� ������?

[Sergey Nikolaenko]

"St. Alex" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
>> > ===========================================
> > ÔÁÂÌÉÃÁ
> > CREATE TABLE AAA(
> >    í INTEGER NOT NULL
> > )
> > insert into AAA values(1)
> > insert into AAA values(2)
> > insert into AAA values(4)
> > insert into AAA values(5)
> > insert into AAA values(8)
> > insert into AAA values(9)
> > insert into AAA values(11)
> > insert into AAA values(14)
> > insert into AAA values(15)
> >
> > ÐÏÌÕÞÉÔØ ÏÔÓÕÔÓÔ×ÕÀÝÉÅ ÚÎÁÞÅÎÉÑ (3 6 7 10 12 13)
>> >
> > éÎÔÅÒÅÓÎÏ ÂÙÌÏ-ÂÙ ÕÚÎÁÔØ ÒÅÛÅÎÉÅ ÚÁÄÁÞËÉ. ;-)

select A1.M + 1,
(select min(A2.M) from AAA A2 where A2.M > A1.M) - 1
from AAA A1
where A1.M + 1 <> (select min(A2.M) from AAA A2 where A2.M > A1.M)


òÅÛÅÎÉÅÑ, ÅÓÌÉ ÓËÌÅÒÏÚ ÎÅ ÏÂÍÁÎÙ×ÁÅÔ, ÏÔ óÅÒÇÅÑ âÕÚÁÄÖÉ