select max(salary) from employees; select min(salary) from employees; select avg(salary) from employees; select count(salary) from employees; select sum(salary) from employees; 1. 2. 3. 4. 5. 6. 也可以这样写: select max(salary) 最高工资, min(salary) 最低工资, sum(salary) 工资和, ...
查询工作岗位是 SA_REP 或者工作岗位是 AD_PRES 并且薪水大于 15000 的员工姓名、工作 ID 以及薪水。 select last_name,job_id,salary from employees where job_id = 'SA_REP' or job_id='AD_PRES' and salary > 15000 1. 2. 2.6.2 示例二 查询工作岗位是 SA_REP 或者是 AD_PRES 并且他们的薪水大...
查询每个工种的中有奖金的员工的最高工资>12000的工种编号和最高工资。 ①查询每个工种有奖金的员工的最高工资 ②根据①的结果继续筛选,筛选出最高工资大于12000的 SELECT MAX(salary), job_id FROM employees WHERE commission_pct IS NOT NULL GROUP BY job_id HAVING MAX(salary)>12000 ; 1. 2. 3. 4. ...
1.查询每个工种有奖金的员工的最高工资 select max(salary),job_id from employees where commission_pct is not null group by job_id 1. 2. 3. 4. 删选分组结果中>12000 select max(salary),job_id from employees where commission_pct is not null group by job_id having max(salary)>12000; 1. ...
案例二 返回job_id与141号员工相同 salary比143号员工多的所有员工的姓名 job__id和工资salary SELECT job_id,last_name,salary FROM employees e WHERE salary>( SELECT salary FROM employees e WHERE e.`employee_id`='143' )AND job_id=( SELECT job_id FROM employees e WHERE e.`employee_id`='141...