没有合适的资源?快使用搜索试试~ 我知道了~
数据库-查询语句知识点
需积分: 0 0 下载量 70 浏览量
2024-03-18
18:24:23
上传
评论
收藏 1.52MB PDF 举报
温馨提示
试读
18页
数据库查询语句的知识点
资源推荐
资源详情
资源评论
2
--
部
⻔
信
息
--
部
⻔
表
:
dept:department
部
分
,
loc - location
位
置
create table DEPT(
DEPTNO char(2) not null,
DNAME VARCHAR(14),
LOC VARCHAR(13)
);
alter table DEPT add constraint PK_DEPT primary key (DEPTNO);
--
员
⼯
表
:
emp:employee
员
⼯
,
-- mgr :manager
上
级
领
导
编
号
,
hiredate
⼊
职
⽇
期
-- firedate
解
雇
⽇
期
,
common
:
补
助
create table EMP
(
EMPNO char(4) primary key,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR char(4),
HIREDATE DATE,
SAL double(7,2),
COMM double(7,2),
DEPTNO char(2)
);
alter table EMP
add constraint FK_DEPTNO foreign key (DEPTNO)
references DEPT (DEPTNO);
create table SALGRADE
(
GRADE char(1) primary key,
LOSAL double(7,2),
HISAL double(7,2)
);
create table BONUS
(
ENAME VARCHAR(10),
JOB VARCHAR(9),
SAL double(7,2),
COMM double(7,2)
);
--
插
⼊
数据
insert into DEPT (DEPTNO, DNAME, LOC)
values ('10', 'ACCOUNTING', 'NEW YORK');
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
SQL
3
insert into DEPT (DEPTNO, DNAME, LOC)
values ('20', 'RESEARCH', 'DALLAS');
insert into DEPT (DEPTNO, DNAME, LOC)
values ('30', 'SALES', 'CHICAGO');
insert into DEPT (DEPTNO, DNAME, LOC)
values ('40', 'OPERATIONS', 'BOSTON');
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17', 800, null, 20);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20', 1600, 300, 30);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22', 1250, 500, 30);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02', 2975, null, 20);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28', 1250, 1400, 30
);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01', 2850, null, 30);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09', 2450, null, 10);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7788', 'SCOTT', 'ANALYST', '7566', '1987-04-19', 3000, null, 20);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7839', 'KING', 'PRESIDENT', null, '1981-11-17', 5000, null, 10);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08', 1500, 0, 30);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7876', 'ADAMS', 'CLERK', '7788', '1987-05-23', 1100, null, 20);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03', 950, null, 30);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03', 3000, null, 20);
insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23', 1300, null, 10);
insert into SALGRADE (GRADE, LOSAL, HISAL)
values ('1', 700, 1200);
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
4
单
表
查
询
insert into SALGRADE (GRADE, LOSAL, HISAL)
values ('2', 1201, 1400);
insert into SALGRADE (GRADE, LOSAL, HISAL)
values ('3', 1401, 2000);
insert into SALGRADE (GRADE, LOSAL, HISAL)
values ('4', 2001, 3000);
insert into SALGRADE (GRADE, LOSAL, HISAL)
values ('5', 3001, 9999);
--
查
看
表
:
select * from dept;
select * from emp;
select * from salgrade;
select * from bonus;
84
85
86
87
88
89
90
91
92
93
94
95
96
97
剩余17页未读,继续阅读
资源评论
冰焰435
- 粉丝: 33
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功