最新话题
-
1 SELECT MAX(salary),MIN(salary),AVG(salary),SUM(salary) FROM employees; 2 SELECT job_id,MAX(salary)...0220 -
2 SELECT MAX(salary),MIN(salary),AVG(salary),SUM(salary) FROM employees; 3 SELECT job_id,MAX(salary)...0260
-
第八章 子查询 需求：谁的工资比Abel高？ SELECT salary FROM employees WHERE last_nameAbel; SELECT last_name,salary F...0223
-
第8章 子查询 需求：谁的工资比Abel高？ 方式1： SELECT salary FROM employees WHERE last_nameAbel; SELECT last_name,sa...0261
-
-
-
-
-
-
-
GROUP BY having 的使用（作用：用来过滤数据） WHERE ，过滤数据 GROUP BY 分组之后，提到HAVING 从需求出发 练习：查询各个部门中最高工资比10000高的部门信息 错...0296
-
谁的工资比Abel高 方式一 SELECT salary FROM employees WHERE last_nameAbel; SELECT last_name,salary FROM empl...0318
-
第八章 子查询 需求：谁的工资比Abel高？ 方式一： SELECT salary from employees where last_nameAble; SELECT last_name,salar...0306 -
SELECT max(salary),min(salary),avg(salary),sum(salary) from employees; SELECT job_id,max(salary),min...0321
-
随堂练习 SELECT max(salary),MIN(salary),AVG(salary),SUM(salary) FROM employees SELECT job_id,MAX(salary)...0224
-
子查询 需求：谁的工资比Abel的高！ 方法1： SELECT salary from employees WHERE last_nameAbel; SELECT last_name, salary ...0242
-
子查询 需求：谁的工资比Abel高 方式1： SELECT salary from employees where last_nameAbel; SELECT last_name,salary ...0266
-
SELECT MAX(salary),MIN(salary),AVG(salary),SUM(salary) from employees; SELECT job_id,MAX(salary),MIN...0226
-
2.查询公司员工工资的最大值，最小值，平均值，总和 SELECT MAX(salary),MIN(salary),AVG(salary),SUM(salary) from employees; 3.查...0313
-