例如创建一个表
create table stz
(
stuNO int primary key ,
subject nvarchar(20) not null,
score int not null
)
insert into stz values(1000 ,'数学',90)
insert into stz values(1001,'语文',90)
insert into stz values(1002,'英语',90)
insert into stz values(1001 ,'数学',90)
insert into stz values(1002,'语文',90)
insert into stz values(1000,'英语',90)
insert into stz values(1002 ,'数学',90)
insert into stz values(1000,'语文',90)
insert into stz values(1001,'英语',90)
-- 现在的情况是
select * from stz;
&n
