统计各个部门的工资记录数

最新推荐文章于 2023-04-14 13:03:25 发布

a大数据yyds

最新推荐文章于 2023-04-14 13:03:25 发布

阅读量344

点赞数 1

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/qq_45765882/article/details/118754344

版权

mysql 专栏收录该内容

16 篇文章 2 订阅

订阅专栏

在这里插入图片描述

drop table if exists departments ;
drop table if exists dept_emp ;
drop table if exists salaries ;
CREATE TABLE departments (
dept_no char(4) NOT NULL,
dept_name varchar(40) NOT NULL,
PRIMARY KEY (dept_no));
CREATE TABLE dept_emp (
emp_no int(11) NOT NULL,
dept_no char(4) NOT NULL,
from_date date NOT NULL,
to_date date NOT NULL,
PRIMARY KEY (emp_no,dept_no));
CREATE TABLE salaries (
emp_no int(11) NOT NULL,
salary int(11) NOT NULL,
from_date date NOT NULL,
to_date date NOT NULL,
PRIMARY KEY (emp_no,from_date));
INSERT INTO departments VALUES(‘d001’,‘Marketing’);
INSERT INTO departments VALUES(‘d002’,‘Finance’);
INSERT INTO dept_emp VALUES(10001,‘d001’,‘2001-06-22’,‘9999-01-01’);
INSERT INTO dept_emp VALUES(10002,‘d001’,‘1996-08-03’,‘9999-01-01’);
INSERT INTO dept_emp VALUES(10003,‘d002’,‘1996-08-03’,‘9999-01-01’);
INSERT INTO salaries VALUES(10001,85097,‘2001-06-22’,‘2002-06-22’);
INSERT INTO salaries VALUES(10001,88958,‘2002-06-22’,‘9999-01-01’);
INSERT INTO salaries VALUES(10002,72527,‘1996-08-03’,‘9999-01-01’);
INSERT INTO salaries VALUES(10003,32323,‘1996-08-03’,‘9999-01-01’);