Geek asks and answers

Cross server, standard SQL for creating comma delimited lists

I look, but I can’t find anything. Is there a standard SQL standard for generating output like this TSQL? I would like one query to work the same as on sqlite, mysql, postgresql or sql server. Is something like this possible?

+5
source share
1 answer

As I understand your question, you are looking for a cross-database method to aggregate values ​​in a column into a comma-separated list. As far as I know, there is no standard aggregate for this (and on PostgreSQL, before I added any new aggregates, I wrote my own aggregates for this).

, , , , , db.

, , , , db, .

, . : db, , SP db .

+2

More articles:


All Articles