芙华歪脖子为什么不是列级庄的酒?
第一次听说芙华歪脖子,方便把照片发过来看看吗?
数据库中行级转换成列级有哪些实际应用?
??首先,我们需要建立一个表,详细内容请参考下文: create table score( Name varchar
(10), Subject varchar
(10), Result int)go -- Insert some data to score tableinsert into score(Name , Subject , Result) values('Jason' , 'Chinese' , 74)insert into score(Name , Subject , Result) values('Jason' , 'Math' , 83)insert into score(Name , Subject , Result) values('Jason' , 'Physic' , 93)insert into score(Name , Subject , Result) values('Bosco' , 'Chinese' , 74)insert into score(Name , Subject , Result) values('Bosco' , 'Math' , 84)insert into score(Name , Subject , Result) values('Bosco' , 'Physic' , 94)go -- useing PIVOT operatorSELECT * FROM( select Name,Subject,Result from score) as XPIVOT( Sum(Result) FOR Subject IN ([Chinese],[Math],[Physic])) AS PVT -- useing static SQL。
- 上一篇:苹果酒,苹果酒的功效和作用
- 下一篇:干型起泡酒,干型起泡酒的适饮温度