数据库原理及应用开发技术SQL3.ppt

课堂练习 找出所在部门在“CHIKAGO”,各个不同职位的平均工资，且每个职位的人数在2人以上。 3.8.1 比较条件 条件类型 Example ,,=,= SELECT * FROM employees WHERE salary = 2500; ANY,SOME SELECT * FROM employees WHERE salary = ANY (SELECT salary FROM employees WHERE department_id = 30); ALL SELECT * FROM employees WHERE salary = ALL ( 1400, 3000); 3.8.2 逻辑条件 逻辑类型 Example NOT SELECT * FROM employees WHERE NOT (job_id IS NULL); SELECT * FROM employees WHERE NOT (salary BETWEEN 1000 AND 2000); AND\OR SELECT * FROM employees WHERE job_id = ’PU_CLERK’ AND[OR] department_id = 30; 3.8.3 成员条件 类型