文档介绍:数据库系统概论》课程之实验二
交互式 SQL
1 实验目的
熟悉数据库的交互式SQL工具。
2.熟悉通过 SQL 对数据库进行操作
3. 完成作业的上机练****br/>2 实验工具 RDBMS
利用RDBMS及其交互式查询工具来操作SP1'
,'J3'
,100);
INSERT
INTO
SPJ
VALUES
('S1',
'P1'
,'J4'
,700);
INSERT
INTO
SPJ
VALUES
('S1',
'P2'
,'J2'
,100);
INSERT
INTO
SPJ
VALUES
('S2',
'P3'
,'J1'
,400);
INSERT
INTO
SPJ
VALUES
('S2',
'P3'
,'J2'
,200);
INSERT
INTO
SPJ
VALUES
('S2',
'P3'
,'J4'
,500);
INSERT
INTO
SPJ
VALUES
('S2',
'P3'
,'J5'
,400);
INSERT
INTO
SPJ
VALUES
('S2',
'P5'
,'J1'
,400);
INSERT
INTO
SPJ
VALUES
('S2',
'P5'
,'J2'
,100);
INSERT
INTO
SPJ
VALUES
('S3',
'P1'
,'J1'
,200);
INSERT
INTO
SPJ
VALUES
('S3',
'P3'
,'J1'
,200);
INSERT
INTO
SPJ
VALUES
('S4',
'P5'
,'J1'
,100);
INSERT
INTO
SPJ
VALUES
('S4',
'P6'
,'J3'
,300);
INSERT
INTO
SPJ
VALUES
('S4',
'P6'
,'J4'
,200);
INSERT
INTO
SPJ
VALUES
('S5',
'P2'
,'J4'
,100);
INSERT
INTO
SPJ
VALUES
('S5',
'P3'
,'J1'
,200);
INSERT
INTO
SPJ
VALUES
('S5',
'P6'
,'J2'
,200);
INSERT
INTO
SPJ
VALUES
('S5',
'P6'
,'J4'
,500);
2•完成课后****题所要求的查询:
SNO
1
S1
2
S2
3
S3
4
S4
5
S5
(l).a. SELECT DISTINCT SNO FROM SPJ WHERE JNO='J1' 结果:
b. SELECT DISTINCT SNO FROM SPJ WHERE JNO='J1' AND PNO='P1'
rq
SNO
2 S3 |
C. SELECT DISTINCT SNO FROM P,SPJ WHERE JNO='J1' AND ='P1' AND
COLOR='红'
o
SNO
Io
2 S3 |