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

[������� �����]

> ëÏÇÄÁ-ÔÏ(24 ÁÐÒÅÌÑ 2006Ç 11:30) Konstantin R. Beliaev ÓÐÒÁÛÉ×ÁÌ:"ÞÔÏ 
> ÄÏÌÖÅÎ
> ÚÎÁÔØ ËÁÎÄÉÄÁÔ, ÓÞÉÔÁÀÝÉÊ ÓÅÂÑ ÓÐÅÃÉÁÌÉÓÔÏÍ ÐÏ SQL" É Sergey Nikolaenko 
> ÄÁÌ ÔÅÓÔÏ×ÙÅ ÚÁÄÁÎÉÑ, ÏÄÎÏ ÉÚ ÚÁÄÁÎÉÊ ÂÙÌÏ ÔÁËÉÍ:
> äÌÑ ÄÕÛÉ 2:
> ===========================================
> ÔÁÂÌÉÃÁ
> 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)
> . ñ ÎÅ ÎÁÛÅÌ ÒÅÛÅÎÉÑ :(, É ËÏÇÄÁ ÍÎÅ ÐÏÎÁÄÏÂÉÌÏÓØ ×Ù×ÏÄÉÔØ ÓÔÁÔÉÓÔÉËÕ ÚÁ 
> ÔÅËÕÝÉÅ ÓÕÔËÉ Ó ÒÁÚÂÉ×ËÏÊ ÐÏ ÞÁÓÁÍ, Ñ ÎÅ ÐÒÉÄÕÍÁÌ ÎÉÞÅÇÏ ÌÕÞÛÅÇÏ ËÁË 
> ÓÄÅÌÁÔØ ÔÁÂÌÉÞËÕ × ËÏÔÏÒÕÀ ×ÓÔÁ×ÉÌ ÞÉÓÌÁ ÏÔ 1 ÄÏ 24, Á ×ÔÏÒÏÊ ÓÔÏÌÂÅà 
> ÓÏÄÅÒÖÁÌ ÎÕÌÉ É ÄÖÏÉÎÉÌ Ó ÎÅÊ Ó×ÏÉ ÄÁÎÎÙÅ, ÐÏÌÕÞÁÑ ËÁË-ÂÙ ÄÁÎÎÙÅ ÚÁ ×ÅÓØ 
> ÄÅÎØ É ÔÁÍ ÇÄÅ ÎÅ ÂÙÌÏ ÜÔÉÈ ÄÁÎÎÙÈ, ÐÏÌÕÞÁÌ ÎÕÌÉ.
>
> éÎÔÅÒÅÓÎÏ ÂÙÌÏ-ÂÙ ÕÚÎÁÔØ ÒÅÛÅÎÉÅ ÚÁÄÁÞËÉ. ;-)

ÒÅÛÅÎÉÅ ËÏÎËÒÅÔÎÏ ÜÔÏÊ ÚÁÄÁÞÉ

select r.RDB$RELATION_ID
from RDB$RELATIONS r
where r.RDB$RELATION_ID between (select min(M) from AAA) and (select max(M) 
from AAA)
  and not exists (select * from AAA where M = r.RDB$RELATION_ID)