³
, New/QBE Query Database Desktop. Select File, ' , . ϳ Open .
. ϳ ' ( ).
:
v ;
v ;
v SQL-.
, . ( ) , :
o ;
o insert ;
o delete ;
o set .
Query/Run Query Database Desktop . .
, , Query/Show SQL SQL. SQL Editor, SQL. SQL- ', .
(Save) ' (Save as). (Open). QBE. ( File Database Desktop.)
³
, :
v ;
v + ;
v ;
v ;
v G .
, . , , . . () .
|
|
{ , . 22.14, Personnel , ( p_salary) 3500. , ( Name) ( Position).
Personnel.db P_Code v P_Name v P_Position P_Birthday P_Salary >=3500 P_Note
. 22.14. ³
P_Salary .}
, , '. , , .
{ ³ ,
, . 22.15, , i , , P__Salar; 3500. Name. - SALARY >=3500}
, , (and) (or).
' . , , _Salary 3500.. 5000, SALARY >=3500,<=5000.
' . , , . 22.17, , _Position . . Personnel.db P_Code P_Name P_Position P_Birthday P_Salary P_note
V V = V V
V V = V V
( ). - .
. , . 22.17 p_Birthday, .
<Ctrl> <Delete>. - , .
. ' , .
, , . 22.18, , p_Position , p_saiary 3000. p_Name,
P__Position P_Salary.
Personnel.db P_Code P_Name P_Position P_Birthday P_Salary P_note
V V = V V>=3000
:
|
|
;
.
, . , , , changeto.
.
P_Code P_Name P_Position P_Birthday P_Salary P_Note
= changeto 4700
, .