Dusan Kolesar wrote: > > Hello list, > Is it posible to do in SAP DB something like: > SELECT CONCAT (column1 || ', ') FROM t1 GROUP BY column2 > > Manual says: > The GROUP clause allows the functions SUM, AVG, MAX/MIN, COUNT, STDDEV, > and VARIANCE > to be applied not only to entire result tables but also to groups of rows > within a result table. > > Or is there any other way how to obtain such a result? > Thank you for your support. >
If a GROUP BY - clause is given, every column has to be part of this clause OR part of a aggregate function like SUM/MIN/MAX/COUNT/... --> your select is not possible. And, by the way, what should the semantic be if all rows with the same column2-value are put together and one of the column1-values is used to produce the output for the corresponding resultrow? Which column1-value ???? Which problem do you want to solve? Elke SAP Labs Berlin > Dusan > > -- > Dusan Kolesar > Helsinska 19 > 040 13 Kosice > Slovakia > e-mail : [EMAIL PROTECTED] > ICQ# : 160507424 > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
