2

In SQL we could add group by clause -- then do sum, count, or avg of a particular (numeric) column. Is there a way to "merge" / "concatenate" particular column -- for each group?

I need this done in one SQL statement

ekad
  • 14,436
  • 26
  • 44
  • 46
iwan
  • 7,269
  • 18
  • 48
  • 66
  • Not in standard SQL. What RDBMS are you using? – Martin Smith Jul 21 '10 at 00:27
  • 1
    possible duplicate of [How do I Create a Comma-Separated List using a SQL Query?](http://stackoverflow.com/questions/1817985/how-do-i-create-a-comma-separated-list-using-a-sql-query). Commas aside, the functionality is the same. – OMG Ponies Jul 21 '10 at 00:28

1 Answers1

1

i found the answer in below link http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php

iwan
  • 7,269
  • 18
  • 48
  • 66