返回首页

您好,

我需要根据明智的细节,如宗教的数据

COL1 COL2 COL3
印度耆那教的穆斯林
但我的数据,就像是在一列

穆斯林
印度教
耆那教
我怎样才能实现this.Please帮我

回答

评论会员:游客 时间:2012/02/07
RaisKazi:在SQLServer中使用这个支点。有更多的信息,看看下面的链接。imgsrc=
阿米尔Mahfoozi
评论会员:游客 时间:2012/02/07
,喜jagadeesh你的问题是有点晦涩,但一般到多个列一列是一个通用的方法:codeprelang="SQL"spanclass="code-keyword"select/span*,spanclass="code-string"'/spanspanclass="code-string"muslim'/spancol1,spanclass="code-string"'/spanspanclass="code-string"'/spancol2,spanclass="code-string"'/spanspanclass="code-string"'/spancol3spanclass="code-keyword"from/spantable1spanclass="code-keyword"where/spanreligion=spanclass="code-string"'/spanspanclass="code-string"muslim'/spanspanclass="code-keyword"union/spanspanclass="code-keyword"select/span*,spanclass="code-string"'/spanspanclass="code-string"'/spancol1,spanclass="code-string"'/spanspanclass="code-string"hindu'/spancol2,spanclass="code-string"'/spanspanclass="code-string"'/spancol3spanclass="code-keyword"from/spantable1spanclass="code-keyword"where/spanreligion=spanclass="code-string"'/spanspanclass="code-string"hindu'/spanspanclass="code-keyword"union/spanspanclass="code-keyword"select/span*,spanclass="code-string"'/spanspanclass="code-string"'/spancol1,spanclass="code-string"'/spanspanclass="code-string"'/spancol2,spanclass="code-string"'/spanspanclass="code-string"jain'/spancol3spanclass="code-keyword"from/spantable1spanclass="code-keyword"where/spanreligion=spanclass="code-string"'/spanspanclass="code-string"jain'/span/pre/code希望它帮助