546_____________________________________________ 

10.1.2   Select

10.1.2.1    

         
SQL    Select.      !
,        ^
       .

      C++Builder Query,   
   Select        
    .    
 C++Builder,     Query   ]
Data Access     DatabaseName  dbP (  
 ,      ).   ]
 DataSource     DataSet  Queryl.  
   DBGrid     DataSource  DataSourcel.

        SQL 
 SQL      SQL  Queryl,   
    ,    
   Active  Queryl  true.     
    .

    Select.     !
 :

SELECT <  > FROM <>

WHERE < > ORDER BY <  -
  WHERE  ORDER BY   . 
 WHERE    :   ,  
  .  ORDER BY   
 .

<>     Table,      , 
  , , Pers.      c

        
  Select,     ,  
.   . , 

SELECT Earn, Nam, Par, Year_b FROM Pers

,     Fam, Nam, Par  Year_b   Pers. 
    SQL  Queryl,    (
tive  Queryl  true   .

      *    ,  }
   . , 

SELECT * FROM Pers

   .

       ,      
  +, -, *, /.    
   : AS <>.    
  ,      -,  
      .  :

       .

      , 
    Table      
   OnCalcFields. ,    
     ,     
. ,    ,  Query, 