Ðàçðàáîòêà áàç äàííûõ â Delphi. 11 Óðîêîâ

       

 Âñå ïîëÿ â ïðîèçâîëüíîì ïîðÿäêå


SELECT first_name, last_name, phone_no,
       location, phone_ext, emp_no

FROM phone_list      ïîëó÷èòü ñïèñîê ñëóæåáíûõ òåëåôîíîâ
                                                         âñåõ ðàáîòíèêîâ ïðåäïðèÿòèÿ
                                                         ñî âñåé íåîáõîäèìîé èíôîðìàöèåé,
                                                         ðàñïîëîæèâ èõ â òðåáóåìîì ïîðÿäêå

FIRST_NAME LAST_NAME PHONE_NO       LOCATION      PHONE_EXT EMP_NO

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

Terri      Lee       (408) 555-1234 Monterey      256           12

Oliver H.  Bender    (408) 555-1234 Monterey      255          105

Mary S.    MacDonald (415) 555-1234 San Francisco 477           85

Michael    Yanowski  (415) 555-1234 San Francisco 492          127

Robert     Nelson    (408) 555-1234 Monterey      250            2

Kelly      Brown     (408) 555-1234 Monterey      202          109

Stewart    Hall      (408) 555-1234 Monterey      227           14

...



Ñîäåðæàíèå ðàçäåëà