python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - group-concat

LEFT JOIN limited number of rows with GROUP_CONCAT too slow

I boiled the question down in the db fiddle below. I have an object table and an images table. X images can be assigned to an object. Now I have a list where a configurable amount of images needs to b...
test-img

Mike

mysql

left-join

group-concat

Votes: 0

Answers: 3

Latest Answer

The first thing I notice in your dbfiddle is that you have no index on images(oid), so your condition in your subquery is doing a table-scan of the images table. That could be a part of the performanc...
test-img

Bill Karwin

Concatenate one column over a resultset like kind of group_concat

I am currently writing on a SPARQL query (GraphDB) and try to concatenate the results of one column to avoid the kind of "duplicates". My current query looks like this SELECT ?label ?otaupda...
test-img

Larry

sparql

group-concat

graphdb

Votes: 0

Answers: 1

Latest Answer

The comment of @UninformedUser lead to the answer: SELECT ?charger ?label ?target (group_concat(?otaupdater; separator=", ") AS ?otaupdaters) WHERE { ?charger rdf:type mymodel:SoftwarePacka...
test-img

Larry

Add second column to order by mysql in a group_concat

I have this query I made based on someone else question here. SELECT *, FIND_IN_SET( score, ( SELECT GROUP_CONCAT( score ORDER BY score ASC) FROM EventPlayerResult WHERE eventId = 'EventTest0') ) AS p...
test-img

DrDoom

mysql

sql-order-by

group-concat

find-in-set

Votes: 0

Answers: 1

Latest Answer

You should use the player and not the score inside GROUP_CONCAT() so that the players are ranked by score first and then by energyLeft. Assuming there is a column like player_id in the table: SELECT *...
test-img

forpas

How to combine multiple rows to multiple col name with variable string in mssql?

Input fruit season price apple spring 15 apple summer 20 apple autumn 35 apple winter 55 banana spring 13 banana summer 2 banana autumn 3 banana winter 5 peach spring 40 peac...
test-img

Herbert

sql

sql-server

database

concatenation

group-concat

Votes: 0

Answers: 4

Latest Answer

This is a basic way to do it using conditional aggregation, without needing to pivot: select fruit, SUM(CASE WHEN season = 'spring' then price else 0 END) SpringPrice, SUM(CASE WHEN season = 'autumn' ...
test-img

Marcel Marino

Posts

Questions

Blogs

Jobs