create table demo11 (dn int, rn varchar(max)) insert into demo11 values(1,’A’),(1,’A-1′),(1,’A-3′),(2,’A’),(2,’B’),(2,’C’) ————- |dn |rn | ————- |1 |A | |1 |A-1| |1 |A-3| |2 |A
create table demo11 (dn int, rn varchar(max)) insert into demo11 values(1,’A’),(1,’A-1′),(1,’A-3′),(2,’A’),(2,’B’),(2,’C’) ————- |dn |rn | ————- |1 |A | |1 |A-1| |1 |A-3| |2 |A