This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / 再来一个SQL问题探讨 - Concatenation. Thanks for your input.
-brother-pooh(Pooh哥哥);
2006-11-22
{1293}
(#3335046@0)
-
啊？这问题不是刚问过吗？ORACLE解决方案：到asktom.oracle.com搜索一下stragg
-newkid(newkid);
2006-11-22
(#3335132@0)
-
Try UDF?
-marsher(marsher);
2006-11-22
(#3335143@0)
-
One SQL Query in MySQLSelect count(1) as NewId, a.C1 as NewC1, a.NewC2
from (select c.C1, group_concat(c.C2 ORDER BY c.Id SEPARATOR '') as NewC2 from T1 c group by c.C1) as a, (select distinct d.C1 from T1 d) as b
where a.C1 >= b.C1
group by a.C1
order by NewId
-looi500(looi);
2006-11-22
{249}
(#3336200@0)