ïÊ ËÁË ÉÎÔÅÒÅÓÎÏ.

Not in ËÁË ÒÁÚ ÐÒÁ×ÉÌØÎÏ ÏÔÒÁÂÁÔÙ×ÁÅÔ. åÓÌÉ × In ÅÓÔØ null - ×ÙÒÁÖÅÎÉÅ, ÔÏ 
ÒÅÚÕÌØÔÁÔ ÄÏÌÖÅÎ ÂÙÔØ False. ðÏÆÉÇ, in ÉÌÉ not in.

select 'Ok' from  rdb$database
   where 0 not in  (null, 0)

= ÐÕÓÔÏÊ ÎÁÂÏÒ.

á ×ÏÔ ×ÙÒÁÖÅÎÉÅ:

select 'Ok' from  rdb$database
   where 0 in  (null, 0)

- ×ÏÚ×ÒÁÝÁÅÔ Ok. á ÎÅ ÄÏÌÖÎÏ.

óÔÁÌÏ ÂÙÔØ, ÄÅÊÓÔ×ÉÔÅÌØÎÏ ÂÁÇ? 



Ответить