--建立测试环境
Create Table TEST
(OrderID Int,
line_no Int,
content Varchar(50))
--插入数据
Insert TEST Values(1, 1, 'beijing')
Insert TEST Values(1, 2, 'telcom')
Insert TEST Values(1, 3, 'xxxxx')
Insert TEST Values(2, 1, 'shanghai')
Insert TEST Values(2, 2, 'bank of china')
Insert TEST Values(2, 3, 'yyyyy')
--测试
Select
OrderID,
(Select content from TEST Where OrderID=A.OrderID And line_no=1) As content1,
(Select content from TEST Where OrderID=A.OrderID And line_no=2) As content2
from TEST A
Group By OrderID
Order By OrderID
--删除测试环境
Drop Table TEST
--结果
/*
OrderID content1 content2
1 beijing telcom
2 shanghai bank of china
*/
Create Table TEST
(OrderID Int,
line_no Int,
content Varchar(50))
--插入数据
Insert TEST Values(1, 1, 'beijing')
Insert TEST Values(1, 2, 'telcom')
Insert TEST Values(1, 3, 'xxxxx')
Insert TEST Values(2, 1, 'shanghai')
Insert TEST Values(2, 2, 'bank of china')
Insert TEST Values(2, 3, 'yyyyy')
--测试
Select
OrderID,
(Select content from TEST Where OrderID=A.OrderID And line_no=1) As content1,
(Select content from TEST Where OrderID=A.OrderID And line_no=2) As content2
from TEST A
Group By OrderID
Order By OrderID
--删除测试环境
Drop Table TEST
--结果
/*
OrderID content1 content2
1 beijing telcom
2 shanghai bank of china
*/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货