老杜mysql 34题

最新推荐文章于 2022-01-14 11:08:50 发布
最新推荐文章于 2022-01-14 11:08:50 发布
阅读量340 收藏 3
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44799348/article/details/117192376
版权

mysql

7、求平均薪水的等级最低的部门的部门名称

mysql> select d.dname,h.* from dept d join (select s.grade,t.* from salgrade s join (select avg (sal) as avg, deptno from emp group by deptno) t on t.avg > s.losal and t.avg < s.hisal) h on d.deptno = h.deptno
    -> where (select h.grade from  dept d join (select s.grade,t.* from salgrade s join (select avg (sal) as avg, deptno from emp group by deptno) t on t.avg > s.losal and t.avg < s.hisal) h on d.deptno = h.deptno order by grade limit 1) = h.grade;
+-------+-------+-------------+--------+
| dname | grade | avg         | deptno |
+-------+-------+-------------+--------+
| SALES |     3 | 1566.666667 |     30 |
+-------+-------+-------------+--------+

8、取得比普通员工（员工代码没有在mgr字段上出现的）的最高薪水还要高的领导人姓名。

在这里插入代码片mysql> select distinct e1.ename from emp e1 join emp e2 on e1.empno = e2.mgr where e1.sal > (select sal from emp where ename not in (select distinct e1.ename from emp e1 join emp e2 on e1.empno = e2.mgr) order by sal desc limit 1);
+-------+
| ename |
+-------+
| FORD  |
| BLAKE |
| KING  |
| JONES |
| SCOTT |
| CLARK |
+-------+

9、取得薪水最高的前五名员工

mysql> select ename, sal from emp where sal >= (select,t.sal from (select sal from emp order by sal desc limit 4,1) t) order by sal desc;
+-------+---------+
| ename | sal     |
+-------+---------+
| KING  | 5000.00 |
| SCOTT | 3000.00 |
| FORD  | 3000.00 |
| JONES | 2975.00 |
| BLAKE | 2850.00 |
+-------+---------+
5 rows in set (0.00 sec)

10、取得薪水最高的第六到第十名员工。

mysql> select ename, sal from emp order by sal desc limit 5,5;
+--------+---------+
| ename  | sal     |
+--------+---------+
| CLARK  | 2450.00 |
| ALLEN  | 1600.00 |
| TURNER | 1500.00 |
| MILLER | 1300.00 |
| WARD   | 1250.00 |
+--------+---------+
5 rows in set (0.00 sec)

11、取得最后入职的五名员工

 select ename, hiredate from emp order by hiredate limit 9, 5;
+--------+------------+
| ename  | hiredate   |
+--------+------------+
| JAMES  | 1981-12-03 |
| FORD   | 1981-12-03 |
| MILLER | 1982-01-23 |
| SCOTT  | 1987-04-19 |
| ADAMS  | 1987-05-23 |
+--------+------------+
5 rows in set (0.00 sec)

12、取得每个薪水等级有多少员工

mysql> select s.grade,count(*) from emp e join salgrade s on e.sal between losal and hisal group by s.grade order by grade;
+-------+----------+
| grade | count(*) |
+-------+----------+
|     1 |        3 |
|     2 |        3 |
|     3 |        2 |
|     4 |        5 |
|     5 |        1 |
+-------+----------+
5 rows in set (0.00 sec)

14、列出所有员工及领导姓名

mysql> select e1.ename as '员工姓名', e2.ename as '领导姓名' from emp e1 left join emp e2 on e1.mgr = e2.empno;
+----------+----------+
| 员工姓名 | 领导姓名 |
+----------+----------+
| SMITH    | FORD     |
| ALLEN    | BLAKE    |
| WARD     | BLAKE    |
| JONES    | KING     |
| MARTIN   | BLAKE    |
| BLAKE    | KING     |
| CLARK    | KING     |
| SCOTT    | JONES    |
| KING     | NULL     |
| TURNER   | BLAKE    |
| ADAMS    | SCOTT    |
| JAMES    | BLAKE    |
| FORD     | JONES    |
| MILLER   | CLARK    |
+----------+----------+
14 rows in set (0.00 sec)

15、列出所有受雇日期早于其直接上级的所有员工的编号，姓名，部门名称。

mysql> select t.empno, t.ename_e, d.dname from dept d join (select e1.empno, e1.ename as ename_e, e1.deptno, e2.ename as '领导姓名' from emp e1 left join emp e2 on e1.mgr = e2.empno where e1.hiredate < e2.hiredate) t on d.deptno = t.deptno;
+-------+---------+------------+
| empno | ename_e | dname      |
+-------+---------+------------+
|  7369 | SMITH   | RESEARCH   |
|  7499 | ALLEN   | SALES      |
|  7521 | WARD    | SALES      |
|  7566 | JONES   | RESEARCH   |
|  7698 | BLAKE   | SALES      |
|  7782 | CLARK   | ACCOUNTING |
+-------+---------+------------+
6 rows in set (0.00 sec)

16、列出部门名称和这些部门的员工信息，同时列出那些没有员工的部门
（其实不需要全连接，写的有问题）

mysql> select d.dname, e.* from dept d left join (select * from emp order by deptno) e on e.deptno = d.deptno union select d.dname, e.* from dept d right join (select * from emp order by deptno) e on e.deptno = d.deptno
    -> ;
+------------+-------+--------+-----------+------+------------+---------+---------+--------+
| dname      | EMPNO | ENAME  | JOB       | MGR  | HIREDATE   | SAL     | COMM    | DEPTNO |
+------------+-------+--------+-----------+------+------------+---------+---------+--------+
| ACCOUNTING |  7934 | MILLER | CLERK     | 7782 | 1982-01-23 | 1300.00 |    NULL |     10 |
| ACCOUNTING |  7839 | KING   | PRESIDENT | NULL | 1981-11-17 | 5000.00 |    NULL |     10 |
| ACCOUNTING |  7782 | CLARK  | MANAGER   | 7839 | 1981-06-09 | 2450.00 |    NULL |     10 |
| RESEARCH   |  7902 | FORD   | ANALYST   | 7566 | 1981-12-03 | 3000.00 |    NULL |     20 |
| RESEARCH   |  7876 | ADAMS  | CLERK     | 7788 | 1987-05-23 | 1100.00 |    NULL |     20 |
| RESEARCH   |  7788 | SCOTT  | ANALYST   | 7566 | 1987-04-19 | 3000.00 |    NULL |     20 |
| RESEARCH   |  7566 | JONES  | MANAGER   | 7839 | 1981-04-02 | 2975.00 |    NULL |     20 |
| RESEARCH   |  7369 | SMITH  | CLERK     | 7902 | 1980-12-17 |  800.00 |    NULL |     20 |
| SALES      |  7900 | JAMES  | CLERK     | 7698 | 1981-12-03 |  950.00 |    NULL |     30 |
| SALES      |  7844 | TURNER | SALESMAN  | 7698 | 1981-09-08 | 1500.00 |    0.00 |     30 |
| SALES      |  7698 | BLAKE  | MANAGER   | 7839 | 1981-05-01 | 2850.00 |    NULL |     30 |
| SALES      |  7654 | MARTIN | SALESMAN  | 7698 | 1981-09-28 | 1250.00 | 1400.00 |     30 |
| SALES      |  7521 | WARD   | SALESMAN  | 7698 | 1981-02-22 | 1250.00 |  500.00 |     30 |
| SALES      |  7499 | ALLEN  | SALESMAN  | 7698 | 1981-02-20 | 1600.00 |  300.00 |     30 |
| OPERATIONS |  NULL | NULL   | NULL      | NULL | NULL       |    NULL |    NULL |   NULL |
+------------+-------+--------+-----------+------+------------+---------+---------+--------+
15 rows in set (0.00 sec)

17、列出至少有5个员工的部门

mysql> select d.dname, e.*
    -> from dept d
    -> join (select deptno, count(*) from emp group by deptno) e
    -> on d.deptno = e.deptno
    -> where e.`count(*)` >= 5;
+----------+--------+----------+
| dname    | deptno | count(*) |
+----------+--------+----------+
| RESEARCH |     20 |        5 |
| SALES    |     30 |        6 |
+----------+--------+----------+
2 rows in set (0.00 sec)

18、列出薪资比SMITH多的所有员工的信息

mysql> select * from emp where sal > (select sal from emp where ename = 'SMITH');
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME  | JOB       | MGR  | HIREDATE   | SAL     | COMM    | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
|  7499 | ALLEN  | SALESMAN  | 7698 | 1981-02-20 | 1600.00 |  300.00 |     30 |
|  7521 | WARD   | SALESMAN  | 7698 | 1981-02-22 | 1250.00 |  500.00 |     30 |
|  7566 | JONES  | MANAGER   | 7839 | 1981-04-02 | 2975.00 |    NULL |     20 |
|  7654 | MARTIN | SALESMAN  | 7698 | 1981-09-28 | 1250.00 | 1400.00 |     30 |
|  7698 | BLAKE  | MANAGER   | 7839 | 1981-05-01 | 2850.00 |    NULL |     30 |
|  7782 | CLARK  | MANAGER   | 7839 | 1981-06-09 | 2450.00 |    NULL |     10 |
|  7788 | SCOTT  | ANALYST   | 7566 | 1987-04-19 | 3000.00 |    NULL |     20 |
|  7839 | KING   | PRESIDENT | NULL | 1981-11-17 | 5000.00 |    NULL |     10 |
|  7844 | TURNER | SALESMAN  | 7698 | 1981-09-08 | 1500.00 |    0.00 |     30 |
|  7876 | ADAMS  | CLERK     | 7788 | 1987-05-23 | 1100.00 |    NULL |     20 |
|  7900 | JAMES  | CLERK     | 7698 | 1981-12-03 |  950.00 |    NULL |     30 |
|  7902 | FORD   | ANALYST   | 7566 | 1981-12-03 | 3000.00 |    NULL |     20 |
|  7934 | MILLER | CLERK     | 7782 | 1982-01-23 | 1300.00 |    NULL |     10 |
+-------+--------+-----------+------+------------+---------+---------+--------+
13 rows in set (0.00 sec)

19、列出所有办事员（CLEARK）的姓名以及它的部门名称，部门的人数

mysql> select h.ename, d.dname, h.count from (select b.ename, a.count, b.deptno from (select count(*) count, deptno from emp group by deptno) a join (select * from emp where job = 'clerk') b on a.deptno = b.deptno) h join dept d on h.deptno = d.deptno;
+--------+------------+-------+
| ENAME  | dname      | count |
+--------+------------+-------+
| SMITH  | RESEARCH   |     5 |
| ADAMS  | RESEARCH   |     5 |
| JAMES  | SALES      |     6 |
| MILLER | ACCOUNTING |     3 |
+--------+------------+-------+
4 rows in set (0.00 sec)

20、列出最低薪金大于1500的各种工作及从事此工作的全部雇员人数。

select e.job, count(*) from emp e join (select min(sal) min, job from emp group by job having min > 1500) h on h.job = e.job group by job;
+-----------+----------+
| job       | count(*) |
+-----------+----------+
| MANAGER   |        3 |
| ANALYST   |        2 |
| PRESIDENT |        1 |
+-----------+----------+
3 rows in set (0.00 sec)

21、列出在部门 “SALES” 工作的员工的姓名，假定不知道销售部的部门编号。
此题坑，略过

22、列出薪资高于公司平均薪资的所有员工，所在部门，上级领导，雇员的工资等级。

mysql> select e.ename,d.dname, s.grade, e2.ename from emp e join dept d on d.deptno = e.deptno join salgrade s on e.sal >= s.losal and e.sal <= s.hisal left join emp e2 on e.mgr = e2.empno where e.sal > (select avg(sal) from emp);
+-------+------------+-------+-------+
| ename | dname      | grade | ename |
+-------+------------+-------+-------+
| FORD  | RESEARCH   |     4 | JONES |
| SCOTT | RESEARCH   |     4 | JONES |
| CLARK | ACCOUNTING |     4 | KING  |
| BLAKE | SALES      |     4 | KING  |
| JONES | RESEARCH   |     4 | KING  |
| KING  | ACCOUNTING |     5 | NULL  |
+-------+------------+-------+-------+
6 rows in set (0.00 sec)

23、列出与“SCOTT” 从事相同工作的所有员工及部门名称

mysql> select e.ename, d.dname from emp e join dept d on e.deptno = d.deptno where job = (select job from emp where ename = 'SCOTT');
+-------+----------+
| ename | dname    |
+-------+----------+
| SCOTT | RESEARCH |
| FORD  | RESEARCH |
+-------+----------+
2 rows in set (0.00 sec)

24、列出薪资等于部门30中员工的薪资的其它员工的姓名和资金（这题神坑）

mysql> select ename, sal from emp where sal in (select distinct sal from emp where deptno = 30) and deptno <> 30;
Empty set (0.00 sec)

25、列出薪资高于在部门30工作的所有员工的薪资的员工姓名和薪资，部门名称。

mysql> select e.ename, e.sal, d.dname from emp e join dept d on e.deptno = d.deptno where e.sal > (select max(sal) from emp where deptno = 30);
+-------+---------+------------+
| ename | sal     | dname      |
+-------+---------+------------+
| JONES | 2975.00 | RESEARCH   |
| SCOTT | 3000.00 | RESEARCH   |
| KING  | 5000.00 | ACCOUNTING |
| FORD  | 3000.00 | RESEARCH   |
+-------+---------+------------+
4 rows in set (0.00 sec)

26、列出在每个部门工作的员工数量，平均工资和平均服务期限。

没搞懂

27、列出所有员工的姓名、部门名称和工资。

mysql> select e.ename, d.dname, e.sal from emp e join dept d on e.deptno = d.deptno;
+--------+------------+---------+
| ename  | dname      | sal     |
+--------+------------+---------+
| SMITH  | RESEARCH   |  800.00 |
| ALLEN  | SALES      | 1600.00 |
| WARD   | SALES      | 1250.00 |
| JONES  | RESEARCH   | 2975.00 |
| MARTIN | SALES      | 1250.00 |
| BLAKE  | SALES      | 2850.00 |
| CLARK  | ACCOUNTING | 2450.00 |
| SCOTT  | RESEARCH   | 3000.00 |
| KING   | ACCOUNTING | 5000.00 |
| TURNER | SALES      | 1500.00 |
| ADAMS  | RESEARCH   | 1100.00 |
| JAMES  | SALES      |  950.00 |
| FORD   | RESEARCH   | 3000.00 |
| MILLER | ACCOUNTING | 1300.00 |
+--------+------------+---------+
14 rows in set (0.00 sec)

28、列出所有部门的详细信息和人数

mysql> select d.*,ifnull( e.`count(*)`,0) from dept d left join (select count(*), deptno from emp group by deptno) e on d.deptno = e.deptno;
+--------+------------+----------+-------------------------+
| DEPTNO | DNAME      | LOC      | ifnull( e.`count(*)`,0) |
+--------+------------+----------+-------------------------+
|     10 | ACCOUNTING | NEW YORK |                       3 |
|     20 | RESEARCH   | DALLAS   |                       5 |
|     30 | SALES      | CHICAGO  |                       6 |
|     40 | OPERATIONS | BOSTON   |                       0 |
+--------+------------+----------+-------------------------+
4 rows in set (0.00 sec)

29、列出各种工作的最低工资及从事此工作的雇员姓名

mysql> select e.ename, t.* from emp e join (select min(sal) as min, job from emp group by job) t on e.sal = t.min and e.job = t.job;
+--------+---------+-----------+
| ename  | min     | job       |
+--------+---------+-----------+
| SMITH  |  800.00 | CLERK     |
| WARD   | 1250.00 | SALESMAN  |
| MARTIN | 1250.00 | SALESMAN  |
| CLARK  | 2450.00 | MANAGER   |
| SCOTT  | 3000.00 | ANALYST   |
| KING   | 5000.00 | PRESIDENT |
| FORD   | 3000.00 | ANALYST   |
+--------+---------+-----------+
7 rows in set (0.00 sec)

30.列出各个部门的manager的最低薪资

mysql> select min(sal), deptno from emp where job = 'manager' group by deptno;
+----------+--------+
| min(sal) | deptno |
+----------+--------+
|  2975.00 |     20 |
|  2850.00 |     30 |
|  2450.00 |     10 |
+----------+--------+
3 rows in set (0.00 sec)

31、列出所有员工的年工资，按年薪从高到低排序

mysql> select ename, (sal + ifnull(comm, 0)) * 12 as yearSal from emp order by yearsal asc;
+--------+----------+
| ename  | yearSal  |
+--------+----------+
| SMITH  |  9600.00 |
| JAMES  | 11400.00 |
| ADAMS  | 13200.00 |
| MILLER | 15600.00 |
| TURNER | 18000.00 |
| WARD   | 21000.00 |
| ALLEN  | 22800.00 |
| CLARK  | 29400.00 |
| MARTIN | 31800.00 |
| BLAKE  | 34200.00 |
| JONES  | 35700.00 |
| SCOTT  | 36000.00 |
| FORD   | 36000.00 |
| KING   | 60000.00 |
+--------+----------+
14 rows in set (0.00 sec)

32、求出员工领导的薪水超过3000的员工名称与领导名称

mysql> select e1.ename as '员工', e2.ename as '领导', e2.sal as '领导薪资' from emp e1 left join emp e2 on e1.mgr = e2.empno where e2.sal >3000;
+-------+------+----------+
| 员工  | 领导 | 领导薪资 |
+-------+------+----------+
| JONES | KING |  5000.00 |
| BLAKE | KING |  5000.00 |
| CLARK | KING |  5000.00 |
+-------+------+----------+
3 rows in set (0.00 sec)

33、求出部门名称中带‘s’字符的部门员工的工资合计，部门人数

mysql> select
    -> d.deptno, d.dname, d.loc, count(e.ename), sum(e.sal)
    -> from
    -> emp e
    -> right join
    -> dept d
    -> on
    -> e.deptno = d.deptno
    -> where
    -> d.dname like '%s%'
    -> group by
    -> d.deptno, d.dname, d.loc;
+--------+------------+---------+----------------+------------+
| deptno | dname      | loc     | count(e.ename) | sum(e.sal) |
+--------+------------+---------+----------------+------------+
|     20 | RESEARCH   | DALLAS  |              5 |   10875.00 |
|     30 | SALES      | CHICAGO |              6 |    9400.00 |
|     40 | OPERATIONS | BOSTON  |              0 |       NULL |
+--------+------------+---------+----------------+------------+
3 rows in set (0.00 sec)

34、给任职日期超过30年的员工加薪10%

mysql> update emp set sal = sal * 1.1 where timestampdiff(year, hiredate, now()) > 30;
Query OK, 14 rows affected (0.03 sec)
Rows matched: 14  Changed: 14  Warnings: 0

mysql> select * from emp;
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME  | JOB       | MGR  | HIREDATE   | SAL     | COMM    | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
|  7369 | SMITH  | CLERK     | 7902 | 1980-12-17 |  880.00 |    NULL |     20 |
|  7499 | ALLEN  | SALESMAN  | 7698 | 1981-02-20 | 1760.00 |  300.00 |     30 |
|  7521 | WARD   | SALESMAN  | 7698 | 1981-02-22 | 1375.00 |  500.00 |     30 |
|  7566 | JONES  | MANAGER   | 7839 | 1981-04-02 | 3272.50 |    NULL |     20 |
|  7654 | MARTIN | SALESMAN  | 7698 | 1981-09-28 | 1375.00 | 1400.00 |     30 |
|  7698 | BLAKE  | MANAGER   | 7839 | 1981-05-01 | 3135.00 |    NULL |     30 |
|  7782 | CLARK  | MANAGER   | 7839 | 1981-06-09 | 2695.00 |    NULL |     10 |
|  7788 | SCOTT  | ANALYST   | 7566 | 1987-04-19 | 3300.00 |    NULL |     20 |
|  7839 | KING   | PRESIDENT | NULL | 1981-11-17 | 5500.00 |    NULL |     10 |
|  7844 | TURNER | SALESMAN  | 7698 | 1981-09-08 | 1650.00 |    0.00 |     30 |
|  7876 | ADAMS  | CLERK     | 7788 | 1987-05-23 | 1210.00 |    NULL |     20 |
|  7900 | JAMES  | CLERK     | 7698 | 1981-12-03 | 1045.00 |    NULL |     30 |
|  7902 | FORD   | ANALYST   | 7566 | 1981-12-03 | 3300.00 |    NULL |     20 |
|  7934 | MILLER | CLERK     | 7782 | 1982-01-23 | 1430.00 |    NULL |     10 |
+-------+--------+-----------+------+------------+---------+---------+--------+
14 rows in set (0.00 sec)
花鸟风月###
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL笔记，老杜，初级MySQL笔记
06-23
MySQL笔记，老杜，初级MySQL笔记
动力节点老杜MySQL数据库教程课堂笔记分享
07-24
本套是MySQL数据库视频教程是动力节点教学总监杜老师讲述，其中详细讲解了MySQL的相关知识，包括MySQL概述，MySQL应用环境，MySQL系统特性，MySQL初学基础，MySQL管理工具，如何安装MySQL及MySQL新特性，通过观看本...
MySQL数据库视频教程老杜最新MySQL教程
09-25
本课程全面讲授了MySQL数据库的相关技术知识，内容全面翔实，是技术开发人员、数据库人员不可多得的视频资料；
数据库---34练习题
X..RH
08-13 973
1、取得每个部门最高薪水的人员名称 select e.ename ,t.* from emp e join (select deptno,max(sal) maxsal from emp group by deptno) t on t.deptno=e.deptno and t.maxsal=e.sal; 2、哪些人的薪水在部门的平均薪水之上 select e.ename, e.sal from emp e join (select deptno,avg(sal) avgsal from emp gro
MySQL 34道训练题以及答案
覃鸿宇的博客
01-16 625
前言：学完了b站的《MySQL基础入门-mysql教程-数据库实战（MySQL基础+MySQL高级+MySQL优化》的课程，自己手写并整理了一份34题的答案，原视频没有提供，包含思路，供各位参考。 一、题目数据库脚本 DROP TABLE IF EXISTS EMP; DROP TABLE IF EXISTS DEPT; DROP TABLE IF EXISTS SALGRADE; CREATE TABLE DEPT (DEPTNO int(2) not null , DNAME V
老杜MySQL笔记总结.md（全）
08-04
老杜MySQL笔记总结.md（全）
MySQL课堂笔记.txt
03-28
老杜mysql全套笔记，简单直接，易懂，精简。可读性很好，自己就是学习此笔记，在此分享，坚持就是胜利，程序猿最有耐心，何愁到不了岸呢，赶紧上岸，go go go
MySQL基础课堂笔记.md
04-13
mysql 的最基础知识总结，包括DDL DML DQL DCL 以及不同分类的理解，类比记忆。一些常见的DDL DMLDCL 的相关语句。
MYSQL练习题34道.zip
06-16
MySQL数据库基础练习题34道，有题有答案，包括练习用.sql文件，适合新手练习。 基础的增删改查。
MySQL 34道大作业学习心得（b站：老杜带你学_mysql入门基础，查询）
小乖乖的臭坏坏
06-13 515
各位端午安康，今天整理一下初学习完SQL，做完作业后的一点心得： t.* ： t为另取的表名，* 表示引用全表； join on：表连接。语法：join 表 on 连接条件； 不要忘记join后面的表格的别名； order by 字段 desc/asc ，降序/升序排列 ； order by 字段 limit a,b 从下标a开始，取b个数据； select distinct 字段 from 表格 … 选取唯一不同值，尽量避免笛卡尔积现象； group by 字段 having 判决条件； not in
老杜 | Mysql的34道作业题
小七自学博客
11-04 752
MySQL34道作业题 1、取得每个部门最高薪水的人员名称 mysql> select e.ename,t.* from emp e join (select deptno,max(sal) as maxsal from emp group by deptno) t on t.deptno = e.deptno and t.maxsal = e.sal; +-------+--------+---------+ | ename | deptno | maxsal | +-------+-------
老杜mysql34道练习题
qq_45385121的博客
11-28 650
MYSQ练习题笔记 数据课结构 DROP TABLE IF EXISTS EMP; DROP TABLE IF EXISTS DEPT; DROP TABLE IF EXISTS SALGRADE; CREATE TABLE DEPT (DEPTNO int(2) not null , DNAME VARCHAR(14) , LOC VARCHAR(13), primary key (DEPTNO) ); CREATE TABLE EMP (EMPNO int(4)
MySQL8.0做老杜34道作业题。有的未必是按照他的思路，未完结。暂停，学新课，回头接着补，毕竟也要复习
pface的博客
01-14 994
老杜带你学_mysql入门基础（mysql基础视频+数据库实战)_哔哩哔哩_bilibili https://www.bilibili.com/video/BV1Vy4y1z7EX?p=132&spm_id_from=pageDriver
MySql_34道经典Sql试题（一）
xiaouncle的博客
04-14 5860
如果能流畅地把这34道题解答出来的话，那对于大多数开发者来说就不会再为写Sql语句而烦恼，写复杂的Sql语句时要分步骤完成，逐步击破最终就能得到你想要的东西。看完这两篇文章不代表你已经学会了，这只是个小小的开端而已。 准备工作 -- Employee中有Bonus=null记录 -- in(nul1,200)只能查询到Bonus=200的记录 SELECT * FROM test.em...
MySql7——34道题目
m0_38057941的博客
10-12 1209
1、取得每个部门最高薪水的人员名称 a.取得每个部门最高薪水 select max(sal) as ‘maxsal’,deptno from emp group by deptno; b.emp表与 a步骤的表，进行连接 select e.ename,e.deptno,e.sal,t.maxsal from emp e join (select max(sal) as ‘maxsal’,deptno from emp group by deptno) t on t.maxsal=e.sal; 2.哪
老杜mysql讲_老杜MySQL学习记录 -- 查询
weixin_34070026的博客
01-26 261
完整的DQL语句：select ... from ... where ... group by ... having ... order by ... limit ...执行顺序 5 1 2 3 4 6 71. 普通...
老杜mysql34题
最新发布
07-29
抱歉，我无法回答关于"老杜mysql34题"的问题。请提供更具体的问题或者相关的引用内容，我将尽力帮助您解答。 #### 引用[.reference_title] - *1* *2* [老杜 | Mysql的34道作业题]...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值