![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql刷题
澜然
坚持
展开
-
MySQL--练习38-67
SQL38 针对actor表创建视图actor_name_view CREATE VIEW actor_name_view AS SELECT first_name AS first_name_v, last_name AS last_name_v FROM actor; SELECT * FROM actor_name_view; SQL39 针对上面的salaries表emp_no字段创建索引idx_emp_no SELECT * FROM salaries FORCE INDEX(idx_em原创 2022-05-04 23:12:40 · 448 阅读 · 0 评论 -
MySQL_练习
SQL22 统计各个部门的工资记录数 # 请你统计各个部门的工资记录数,给出部门编码dept_no、部门名称dept_name以及部门在salaries表里面有多少条记录sum, # 按照dept_no升序排序,以上例子输出如下: SELECT de.dept_no, dept_name, count( * ) as sum FROM departments de, dept_emp mp, salaries sa WHERE de.dept_no = mp.dept_no AND m原创 2022-04-27 21:20:47 · 798 阅读 · 0 评论