         551

	
	3
 1	4
 2	4

     GROUP BY   
      HAVING. ,  
    :

SELECT Dep , count (*)   FROM Pers
GROUP BY Dep HAVING Dep  ''

        . , -
 Query,       SQL,  HAVING
 .   ,     
WHERE  HAVING.      
,  HAVING      , 
WHERE   .  HAVING  .   -
      

SELECT Dep , count!*) _ FROM Pers
WHERE Dep <> ''GROUP BY Dep

     .

10.1.2.3  

,   Select,    
 Select.      ,  -
 ,   ,   . -
,          
.        :

SELECT Fam,Year_b FROM Pers WHERE Year_b=(SELECT max(Year_b) FROM Pers)

      SELECT max(Year_b) FROM
Pers    ,    
WHERE   Select    ( ),
     .

      . , ,
       Pers  Persi,  
 ,     Pers    -
  .      , 
   Database Desktop   Pers,   Tab-
le | Restructure,     ,    Save as  -
       ,     Pers,   -
  Persi.  ,     ,   
Pers,    - . ,      ,
      Persi  Pers, .. 
  .      .

,          -
.    

Select * FROM Pers WHERE Fam IN (SELECT Fam FROM Persi)

  Select Fam from Persi   
  Persi,   WHERE   Select  
   Pers ,       Persi.