SQL基础——SELECT

SELECT first_name

                  ,last_name

                  ,manager_employee_number

FROM employee

WHERE job_code >=43000 AND

                job_code <=439999;

SELECT last_name

FROM employee

WHERE last_name BETWEEN 'r' AND 's';

由于Teradate不区分大小写，所以Rose也会被作为返回结果

SELECT first_name

                 ,last_name

                 ,department_number

FROM employee

WHERE department_number = 401

OR department_number = 403;

SELECT first_name

                 ,last_name

                 ,department_number

FROM employee

WHERE NOT (department_number = 401 OR department_number = 403);