生成左側表的陳述句
create table tb (
name nvarchar(50),
price1 float,
price2 float
)
insert into tb
select '110*300',11.8,15 union all
select '110*300',11.8,18 union all
select '110*300',11.8,20 union all
select '110*300',11.8,25 union all
select '110*300',11.8,30 union all
select '110*300',11.8,35 union all
select '110*70',3.5, 15 union all
select '110*70',7, 15 union all
select '110*70',3.5, 17 union all
select '110*70',7, 17 union all
select '110*70',3.5, 25 union all
select '110*70',7, 25
uj5u.com熱心網友回復：
SELECT
a.name,
STUFF((SELECT DISTINCT '/'+CAST(b.price1 AS VARCHAR) FROM tb b WHERE b.name = a.name FOR XML PATH('')),1,1,'') price1,
STUFF((SELECT DISTINCT '/'+CAST(c.price2 AS VARCHAR) FROM tb c WHERE c.name = a.name FOR XML PATH('')),1,1,'') price2
FROM tb a
GROUP BY a.name
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/234670.html
標籤：基礎類