Delphi. 11



         


. . : . , .

? :

    

    

    

    

    

     (), .

. , WHERE first_name = Ïåòð , WHERE first_name = Ïåòð.

SELECT first_name, last_name, dept_no

FROM employee

WHERE job_code = "Admin"
( ),

FIRST_NAME LAST_NAME DEPT_NO

=============== ==================== =======

Terri Lee 000

Ann Bennet 120

Sue Anne O'Brien 670

Kelly Brown 600

SELECT first_name, last_name, dept_no,

job_country

FROM employee

WHERE job_country <> "USA"
(
),

FIRST_NAME LAST_NAME DEPT_NO JOB_COUNTRY

=============== ================ ======= ==============

Ann Bennet 120 England

Roger Reeves 120 England

Willie Stansbury 120 England

Claudia Sutherland 140 Canada

Yuki Ichida 115 Japan

Takashi Yamamoto 115 Japan

Roberto Ferrari 125 Italy

Jacques Glon 123 France

Pierre Osborne 121 Switzerland