552  10

    WHERE     
 : All  Any. All ,      -
, a Any      . , 

Select * FROM Pers WHERE Year_b >= ALL (SELECT Year_b FROM Persi)

   Pers,       Persi. ,
     Persi  Pers,     
 ,      .  -


Select * FROM Pers WHERE Year_b > ANY (SELECT Year_b FROM Persi)

   Pers,        Persi.

 ,    Select,  
  EXISTS,      ,  
      . , 

SELECT Num, Fam, Year_b FROM Pers pi
WHERE EXISTS (Select Num, Year_b FROM Pers p2
WHERE (pl.Year_b = p2.Year_b) and
(pi.Num != p2.Num))

  ,      .

    SINGULAR,    
 ,        .
, 

SELECT Num, Fam, Year_b From Pers pi
WHERE SINGULAR(Select Num, Year_b FROM Pers p2
WHERE pl.Year_b = p2.Year_b)

  ,       ( 
          
 ).

10.1.2.4  

        . , ,
       . 
 Pers         Dep -
,    .    Dep     -
   Dep       Prosv (true, 
 ).      -
   :

Select Pers.* FROM Pers, Dep WHERE
(Pers.Dep=Dep.Dep)AND(Dep.Proisv=true)

        Pers  Dep,  -
    FROM.      -
  ,    . ,      -
,       ( Dep).   Proisv
    .   WHERE 
Pers.Dep=Dep.Dep     Dep,    Dep   -
 Dep    Pers.   Dep.Proisv=true   -
,     Dep     Pro-
isv = true.

 ,    ,   
 ,    ,     -
 ,    .   
      FROM,    