SqlServer 查询的问题
sql server 查询怎么将下列值
按照cId的值分成3列
例如：
| cId1 | cId2 | cId0 |
|---|---|---|
| A203D53A-A692-46AF-9C3D-0000453FC531 | 9EE29150-DFF6-4FB2-B292-000A3657747B | 57C125E1-9A0D-4AF8-B0AD-00122388F4C0 |
| 47E1972B-53B0-4D43-8C00-002AB9661CCE | 4FB1E188-009C-4150-AD93-002DE24EAB9E | B2EBA976-3E11-4556-82E0-004DA78734B4 |
其中cId1列为cId=1的列 依次类推。
相当于
怎么把
select Id cId0 from table_name where cId=0;
select Id cId1 from table_name where cId=1;
select Id cId2 from table_name where cId=2;
三列值 并起来
无限上升气流君
9 years, 6 months ago
Answers
利用行号
select t0.Id cId0,t1.Id cId1,t2.Id cId2 from
(select Id,ROW_NUMBER() over(order by Id)) rNum from table_name where cId=0) t0
left join
(select Id,ROW_NUMBER() over(order by Id)) rNum from table_name where cId=1) t1 on t0.rNum=t1.rNum
left join
(select Id,ROW_NUMBER() over(order by Id)) rNum from table_name where cId=2) t2 on t1.rNum=t2.rNum
緋紅的蛇
answered 9 years, 6 months ago