表中有很多重复数据,需要它和另外一个表通过身份证号联表查询,但是因为该表重复数据多,查出数据过多
create table Student --学生成绩表
(
id int, --主键
Grade int, --班级
Score int --分数
)
go
insert into Student values(1,1,88)
insert into Student values(2,1,66)
insert into Student values(3,1,75)
insert into Student values(4,2,30)
insert into Student values(5,2,70)
insert into Student values(6,2,80)
insert into Student values(7,2,60)
insert into Student values(8,3,90)
insert into Student values(9,3,70)
insert into Student values(10,3,80)
insert into Student values(11,3,80)