Wednesday, 18 March 2015

XMLAGG Aggreate Sample

Xmlagg to combine multiple rows into single row.


select  id,replace(replace(xmlagg(xmlelement("a",sql) order by id),'<a>',' '),'</a>',' ') AA from sample group by id

No comments:

Post a Comment