SQL语句的简单练习

一个简单的SQL语句练习，也是一个比较经典的横表转纵表练习

效果如下：

 

查询以后达到如下效果;

 

sql语句如下：

 

create table subject(
sid int identity(1,1),
sno int,
subject varchar(10),
score int
)

 insert into subject values(1,'语文',90)
 insert into subject values(1,'数学',70)
 insert into subject values(1,'英语',80)
 insert into subject values(2,'语文',80)
 insert into subject values(2,'数学',90)
 insert into subject values(2,'英语',70)

 select * from  subject

 select DISTINCT s1.sno as '学号',s1.score as '语文',s3.score as '英语',s2.score as '数学' 
from  subject as s1,subject as s2,subject as s3
where s1.sno=s2.sno and s2.sno = s3.sno 
and s1.subject = '语文' and s2.subject = '数学' and s3.subject = '英语'