Aggregation, sort of

#1

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?

#2

"Sashi" <smalladi (AT) gmail (DOT) com> a écrit dans le message de news: 925076bd-3023-44e5-9747-788f803e05dd...oglegroups.com...

Quote:

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

#3

On Jan 27, 11:07*am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

Quote:

"Sashi" <small... (AT) gmail (DOT) com> a écrit dans le message de news: 925076bd-3023-44e5-9747-788f803e0... (AT) a32g2000yqm (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Aggregation, sort of

comp.databases.oracle.misc comp.databases.oracle.misc

Aggregation, sort of - 01-27-2010 , 09:28 AM

Re: Aggregation, sort of - 01-27-2010 , 10:07 AM

Re: Aggregation, sort of - 01-27-2010 , 10:13 AM