DECLARE @TB TABLE
(
ID INT,
VALUE VARCHAR(50)
)
INSERT INTO @TB VALUES(1,'X');
INSERT INTO @TB VALUES(1,'Y');
INSERT INTO @TB VALUES(2,'A');
INSERT INTO @TB VALUES(2,'B');
INSERT INTO @TB VALUES(3,'C');SELECT
ID,VALUE=MIN(VALUE)+
CASE WHEN COUNT(*)=1 THEN ''ELSE
','+MAX(VALUE) ENDFROM @TB GROUP BY ID
(
ID INT,
VALUE VARCHAR(50)
)
INSERT INTO @TB VALUES(1,'X');
INSERT INTO @TB VALUES(1,'Y');
INSERT INTO @TB VALUES(2,'A');
INSERT INTO @TB VALUES(2,'B');
INSERT INTO @TB VALUES(3,'C');SELECT
ID,VALUE=MIN(VALUE)+
CASE WHEN COUNT(*)=1 THEN ''ELSE
','+MAX(VALUE) ENDFROM @TB GROUP BY ID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货