548_____________________________________________ 10

   . , 

SELECT Fam FROM Pers WHERE Sex=false and Year_b > 1960

 ,   ,   1960 .
 Like  :

<> LIKE '-^ >'

         true,   
 ,      >.
         -
 % ,       .   -
  ,      -
   . , 

Fam LIKE 'A%'

,     ,     -
  ( Like     ). 

Fam LIKE '%'

     ,  

Fam LIKE '%%'

    , ,  .
 between ... and  :

<> between <> and <>
       . , 

SELECT Fam, Year_b FROM Pers WHERE Year_b BETWEEN 1960 AND 1970

       ( 
 1960  1970).

 In  :

<> in (<>)

  ,         ;

  . , 

SELECT Fam, Year_b FROM Pers WHERE Fam IN('','',''
     ,  

SELECT Fam, Year_b FROM pers WHERE Year_b IN(1950,1960)

     .

  Select,     ORDER BY, 
  () .     &|
 ,  .    . :

    (     SELECT). 
     .

       ,   '
        . , -


SELECT Dep, Fam, Year_b FROM Pers ORDER BY Year_b

       .
      ,   
    DESC:

SELECT Dep, Fam, Year_b FROM Pers ORDER BY Year_b DESC