Delphi. 11



         

BETWEEN - 2


Sue Anne O'Brien 31275.00

Pierre Osborne 110000.00

, , . - !

SELECT first_name, last_name, salary

FROM employee

WHERE last_name BETWEEN "Nel" AND "Osb"
,

Nel Osb

FIRST_NAME LAST_NAME SALARY

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

Robert Nelson 105900.00

Carol Nordstrom 42742.50

Sue Anne O'Brien 31275.00

Nel Osb . , , , Nel (.. ), Osb (.. - O, Os, Osb), . , BETWEEN , , .

BETWEEN NOT (NOT BETWEEN) , .

SELECT first_name, last_name, hire_date

FROM employee

WHERE hire_date NOT BETWEEN "1-JAN-1989" AND "31-DEC-1993"
(
)

FIRST_NAME LAST_NAME HIRE_DATE

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

Robert Nelson 28-DEC-1988

Bruce Young 28-DEC-1988

Pierre Osborne 3-JAN-1994

John Montgomery 30-MAR-1994

Mark Guckenheimer 2-MAY-1994