实验题目:查询每班成绩前三名的信息
实验数据库:Oracle
实验数据:学生-成绩表(id,学生名,班级名,分数)
建表语句: 15笔数据,俩个班。
create table OnePiece_SC
(
id int,
StudentName varchar(30),
ClassName varchar(30),
Score int
);
insert into OnePiece_SC values (1,'Monkey·D·Lufy','The straw hat Pirates',101);
insert into OnePiece_SC values (2,'Roronoa Zoro','The straw hat Pirates',99);
insert into OnePiece_SC values (3,'Nami','Th1e straw hat Pirates',75);
insert into OnePiece_SC values (4,'Usop','The straw hat Pirates',97);
insert into OnePiece_SC values (5,'Sanj','The straw hat Pirates',80);
insert into OnePiece_SC values (6,'Tony Tony Choppe','The straw hat Pirates',67);
insert into OnePiece_SC values (7,'Nico Robi','The straw hat Pirates',92);
insert into OnePiece_SC values (8,'Franky',&