Top "Group-concat" questions

a function which returns a string representation of the concatenated, non-NULL values of a group

sqlite3 JOIN, GROUP_CONCAT using distinct with custom separator

Given a table of "events" where each event may be associated with zero or more "speakers" and zero or more "…

sql sqlite group-concat
How to prevent GROUP_CONCAT from creating a result when no input data is present?

Given the following MySQL query: SELECT `show`.`id` , GROUP_CONCAT( `showClips`.`clipId` ORDER BY `position` ASC ) AS 'playlist' FROM `show` …

mysql group-concat
MySQL: combining multiple values after a join into one result column

I have a database with a table for publications, each of which can have multiple authors that are stored in …

mysql sql left-join group-concat
Select first and last row from group_concat when grouping sortable days

Referring to my previous questions about the group concat Mysql again, group by and display rest of rows i need …

mysql group-concat
GROUP CONCAT not working for some reason

I'm forming a select statement and am getting this error. FUNCTION GROUP_CONCAT does not exist. Check the 'Function Name …

mysql sql select group-concat
GROUP_CONCAT in Vertica

Suppose we have data something like this: date | campaign | raw | unq ------------+----------+-----+----- 2016-06-01 | camp1 | 5 | 1 2016-06-01 | …

group-concat vertica
Spark: group concat equivalent in scala rdd

I have following DataFrame: |-----id-------|----value------|-----desc------| | 1 | v1 | d1 | | 1 | v2 | d2 | | 2 | v21 | d21 | | 2 | v22 | d22 | |--------------|---------------|---------------| I want …

scala apache-spark group-concat rdd spark-dataframe
Add an inner join to mySQL GROUP_CONCAT statement

Problem: I have a GROUP_CONCAT query that is working as intended, except I'd like to make the concat a …

mysql group-concat
Mysql return more than one row

I have this query. SELECT notes.id,enter.name as 'enter_name',step.title as 'flow status',notes.user_name …

mysql sql group-concat
MySQL query with group contact

Let's say I have a table called "test" with the following design: SELECT type, name, `key` FROM test type | name | …

mysql sql group-concat mysql-select-db