ASE Database forum - How we can do the LIST ASA function in ASE ???

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How we can do the LIST ASA function in ASE ???

George

2005-04-15, 8:24 pm

Hi everyone:

Thre is the LIST function in ASA that returns a
comma-separated list of values.

For example:

The following statement lists employee IDs. Each row in the
result set contains a comma-separated list of employee IDs
for a single department.

SELECT LIST( emp_id )
FROM employee
GROUP BY dept_id
LIST( emp_id )
102,105,160,243,247,
249,266,27,. . .
129,195,299,467,641,
667,690,85,. . .
148,390,586,757,879,
1293,1336,. . .
184,207,318,409,591,
888,992,10,. . .
191,703,750,868,921,
1013,1570,. . .

How can we do the same in ASE ???.

Sincerely

George

Sponsored Links