Re: Aggregation, sort of

"Sashi" <smalladi_at_gmail.com> a écrit dans le message de news: 925076bd-3023-44e5-9747-788f803e05dd_at_a32g2000yqm.googlegroups.com...
| Hi all,
| (How I wish there was a comp.lang.sql for generic sql questions!).
|
| I have a table structured thus:
| Emp_org, emp_dept, emp_sub_dept, emp_language, emp_location.
|
| (This is not my table but an attempt at a simplified example).
|
| So there could be 20 employees with the same emp_org, emp_dept and
| emp_sub_dept.
| But these 20 guys could be speaking different languages located at
| different locations.
|
| Is there a way to structure a query so that I can group the similar
| columns together and concatenate the others?
| So I would end up with
| emp_org, emp_dept, emp_sub_dept, (emp_language || emp_languange..),
| (emp_location || emp_location..)
|
| Hope this is clear enough.
|
| TIA,
| Sashi
| for all the employees who share the common first three fields?

Depending on the version:

T. Kyte's STRAGG function
WM_CONCAT
LISTAGG Regards
Michel Received on Wed Jan 27 2010 - 10:07:51 CST