Re: Aggregation, sort of

From: Sashi <smalladi_at_gmail.com>
Date: Wed, 27 Jan 2010 08:13:22 -0800 (PST)
Message-ID: <261f8d39-8903-4509-8624-6d8f0dbb8638_at_e25g2000yqh.googlegroups.com>

On Jan 27, 11:07 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Sashi" <small..._at_gmail.com> a écrit dans le message de news: 925076bd-3023-44e5-9747-788f803e0..._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

Thank you.
I will check them out.
Regards,
Sashi Received on Wed Jan 27 2010 - 10:13:22 CST