0
answers
How to concatenate strings of a string field in a PostgreSQL 'group by' query?
P粉520545753 2025-12-18 18:43:06
Views 96
0
I am looking for a way to concatenate the strings of a field within a group by query. So for example, I have a table:
| ID | COMPANY_ID | EMPLOYEE |
|---|---|---|
| 1 | 1 | Anna |
| 2 | 1 | Bill |
| 3 | 2 | Carol |
| 4 | 2 | Dave |
and I wanted to group by company_id to get something like:
| COMPANY_ID | EMPLOYEE |
|---|---|
| 1 | Anna, Bill |
| 2 | Carol, Dave |
There is a built-in function in mySQL to do this group_concat
Your Answer
0 answers
Hot tools Tags
Hot Questions
How to pass an array into a SQL Server stored procedure
2026-01-31 22:24:05
What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
2026-01-31 22:02:53
Convert a JavaScript string in dot notation into an object reference
2026-01-31 21:22:07
MySQL error #2014 - Commands out of sync; you can't run this command now [closed]
2026-01-31 21:01:19
How do I format a date in JavaScript?
2026-01-31 20:43:18
Popular tool
vc9-vc14 (32+64 bit) runtime library collection (link below)
Download the collection of runtime libraries required for phpStudy installation
VC9 32-bit
VC9 32-bit phpstudy integrated installation environment runtime library
PHP programmer toolbox full version
Programmer Toolbox v1.0 PHP Integrated Environment
VC11 32-bit
VC11 32-bit phpstudy integrated installation environment runtime library
SublimeText3 Chinese version
Chinese version, very easy to use
Hot Topics
Douyin level price list 1-75
20522
7
20522
7
wifi shows no ip assigned
13634
4
13634
4
Hot Article
What should I do if I can't always get the spot? Ouyitun Bibao multi-currency rotation and rebalancing strategy
2026-04-04
By DDD
Is the Martingale strategy effective? Detailed explanation of Ouyi DCA robot parameter setting
2026-04-03
By DDD
14 Hidden iOS 26 Features You Probably Missed
2026-04-01
By DDD
PHP runtime getting and monitoring script maximum memory limit (bytes)
2026-04-01
By DDD