How to concat all column values from differenct rows returned from a sql query into one value? This is an example:
a query returns:
FOO ------ RES1 RES2 RES3
now I want to have a result like the following one:
FOOCONCAT ----- RES1RES2RES3
Are there any ways to do this in sql?