Mysql数据库学习

QiaoJiansen

已于 2022-09-27 22:12:04 修改

阅读量157

点赞数

分类专栏： MySQL学习文章标签：学习 sql sqlserver

于 2022-09-21 19:44:01 首次发布

本文链接：https://blog.csdn.net/qjpa1234/article/details/126979273

版权

MySQL学习专栏收录该内容

4 篇文章 0 订阅

订阅专栏

Mysql数据库学习（六）

第六章：决胜秋招

Section A：

练习一: 各部门工资最高的员工：

CREATE TABLE Employee
(i_name    CHAR(10)       NOT NULL,
 Salary  INTEGER  NOT NULL,
 DepartmentId INTEGER       NOT NULL,
 PRIMARY KEY (i_name, Salary)
);

INSERT INTO Employee (i_name, Salary, DepartmentId) VALUES ('Joe',	70000, 1);
INSERT INTO Employee (i_name, Salary, DepartmentId) VALUES ('Henry',	80000, 2);
INSERT INTO Employee (i_name, Salary, DepartmentId) VALUES ('Sam',	60000, 2);
INSERT INTO Employee (i_name, Salary, DepartmentId) VALUES ('Max',	90000, 1);

在这里插入图片描述

CREATE TABLE Department
(name    CHAR(10)       NOT NULL,
 PRIMARY KEY (name)
);

INSERT INTO Department (name) VALUES ('IT');
INSERT INTO Department (name) VALUES ('Sales');