Most voted "group-concat" questions
9 questions
Sort by count of
-
6
votes1
answer2147
viewsPass variable value inside nested SELECT
Assuming the following query where we are selecting values, grouping them and then re-grouping the result: SELECT CONCAT (b.label, '|', b.slug) FROM ( SELECT group_concat(name SEPARATOR '$') AS…
-
6
votes2
answers6106
viewsMysql group_concat() in Sqlserver
I created a table for example: I have the following content: select * from table_t; And I need to get the following result: In Mysql I use the following query: select group_concat(concat_ws(' -…
-
3
votes1
answer2214
viewsOperation of group_concat
I have some questions related to the use of group_concat, more specifically for performance. When using group_concat can’t use limit. // a query retorna todos os ID's select group_concat( id ) from…
-
1
votes1
answer241
viewsGroup data from a Query?
I do a GROUP BY in a query result and the result comes this way: I wonder if it is possible to bring together in this way? I wonder if this grouping is best done in PHP or Query and how it can be…
-
1
votes1
answer100
viewsError in GROUP_CONCAT Access function
I am performing the following SQL: SELECT e.titulo, e.descricao, e.obs, e.cupom, e.inicio, e.fim, GROUP_CONCAT(p.nome) AS teste FROM ((eventos e INNER JOIN produtoseventos pe ON e.idevento =…
-
0
votes1
answer422
viewsRepeated data with GROUP_CONCAT
I have a problem when I make one SELECT in my comic book, I’m using GROUP_CONCAT to concatenate the column of phones and email but I’m picking up repeated data. Here is the SELECT: SELECT…
-
0
votes1
answer92
viewsConcatenate Lines with the same User
I have the following consultation: SELECT e.id_taxe, u.nm_user, dt_taxe, SUM(e.vl_taxe) as vl_taxe FROM taxe as e INNER JOIN user as u ON u.id_user = e.id_user WHERE id_enterprise = 86 AND (dt_taxe…
-
0
votes1
answer42
viewsResult SQL statement
Hello! I have a table of a questionnaire, I would like to have a result grouped by "property", making a GROUP_CONCAT in the "answers", according to the model below: property | question | answers 10…
-
0
votes0
answers130
viewsGROUP_CONCAT bringing incomplete response
I am trying to bring all the product names (even the repeated ones) I have registered in a spreadsheet, but the code is stopping in the middle of the process. Can anyone tell me why ? Is there a…