学生表sid,sname,成绩表cid,cname,学生成绩表sid,cid,cscore,要
Jun 07, 2016 pm 04:01 PM--1、建表SQL: --学生表: -- Createtable createtable STUDENT ( SID NUMBERnotnull, SNAME NVARCHAR2(40) ) tablespace CABLESCD pctfree10 initrans1 maxtrans255 storage ( initial64 minextents1 maxextentsunlimited ); --成绩表 -- Createtable creat
--1、建表SQL:
--学生表:
-- Createtable
createtable STUDENT
(
SID NUMBERnotnull,
SNAME NVARCHAR2(40)
)
tablespace CABLESCD
pctfree10
initrans1
maxtrans255
storage
(
initial64
minextents1
maxextentsunlimited
);
--成绩表
-- Createtable
createtable SCORE
(
CID NUMBERnotnull,
CNAME NVARCHAR2(40) notnull
)
tablespace CABLESCD
pctfree10
initrans1
maxtrans255
storage
(
initial64
minextents1
maxextentsunlimited
);
--学生成绩表
-- Createtable
createtableSTUDENGSCORE
(
SID NUMBERnotnull,
CID NUMBERnotnull,
CSCORE NUMBER(4,2)
)
tablespace CABLESCD
pctfree10
initrans1
maxtrans255
storage
(
initial64
minextents1
maxextentsunlimited
);
--2、插入SQL语句:
insert into student
(sid, sname)
values
(001,'ZHAOHY');
insert into student
(sid, sname)
values
(002, 'ZHANGQL');
insert into student
(sid, sname)
values
(003, 'ZHAOHB');
insert into score
(cid, cname)
values
(100, '数电');
insert into score
(cid, cname)
values
(200, '模电');
insert into score
(cid, cname)
values
(300, '英语');
insert into score
(cid, cname)
values
(400, '政治');
select * from score
(001, 100, '60');
insert into studengscore
(sid, cid, cscore)
values
(002, 100, '70');
insert into studengscore
(sid, cid, cscore)
values
(003, 100, '80');
insert into studengscore
(sid, cid, cscore)
values
(003, 200, '90');
insert into studengscore
(sid, cid, cscore)
values
(003, 300, '99');
insert into studengscore
(sid, cid, cscore)
values
(003, 400, '98');
select * from studengscore
--3、查询SQL
select * fromstudengscore;
select * from student;
select * from score;
select cnamefrom score where cid =(select cid fromstudengscore wherecscore=(
selectmax(cscore) fromstudengscore where sid=3 ));

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to write a simple student attendance management system using Java?

Which computer should Geographic Information Science majors choose?

What are the effective ways to prevent students from being addicted to mobile phones?

Guangzhou plans to stipulate that primary and secondary schools can prohibit students from bringing mobile phones, and those allowed to bring in should be managed uniformly

How to implement a simple student test score ranking system using Java?

How to implement a simple student homework marking system in Java?

How to use C++ to implement a simple student test score analysis program?

How does Class Optimization Master send results to parents?
