OracleLes02限制和排序数据.pptx

限制和排序数据;Objectives;课程章节;使用选择功能来限制行;限制选定的行;SELECT employee_id, last_name, job_id, department_id FROM employees WHERE department_id = 90 ;;SELECT last_name, job_id, department_id FROM employees WHERE last_name = Whalen ;;比较条件;SELECT last_name, salary FROM employees WHERE salary = 3000 ;;SELECT last_name, salary FROM employees WHERE salary BETWEEN 2500 AND 3500 ;;SELECT employee_id, last_name, salary, manager_id FROM employees WHERE manager_id IN (100, 101, 201) ;;SELECT first_name FROM employees WHERE first_name LIKE S% ;;使用 LIKE 条件;SELECT last_name, manager_id FROM employees W