How to get list of values in GROUP_BY clause?

by

In mysql, use

SELECT id, GROUP_CONCAT(data)
 FROM yourtable
 GROUP BY id

or use your custom separator:

SELECT id, GROUP_CONCAT(data SEPARATOR ', ')
 FROM yourtable
 GROUP BY id

see GROUP_CONCAT.

More Related Contents:

  1. Select first row in each GROUP BY group?
  2. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  3. Using group by on multiple columns
  4. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  5. GROUP BY with MAX(DATE) [duplicate]
  6. SQL – using alias in Group By
  7. Is there any difference between GROUP BY and DISTINCT
  8. Group by minimum value in one field while selecting distinct rows
  9. must appear in the GROUP BY clause or be used in an aggregate function
  10. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  11. How to group time by hour or by 10 minutes
  12. Concat groups in SQL Server [duplicate]
  13. JOIN two SELECT statement results
  14. SQL query for finding records where count > 1
  15. GROUP BY + CASE statement
  16. SQL Group by & Max
  17. SQL to Entity Framework Count Group-By
  18. SQL GROUP BY CASE statement with aggregate function
  19. Mysql: how to select groups having certain values?
  20. MySQL #1140 – Mixing of GROUP columns
  21. SQL Server Update Group by
  22. Selecting all corresponding fields using MAX and GROUP BY
  23. How can I group time by hour or by 10 minutes?
  24. Huge performance difference when using GROUP BY vs DISTINCT
  25. SQL not a single-group group function
  26. What is the mysterious ‘timestamp’ datatype in Sybase?
  27. Conditional SQL count
  28. SQL query to group by day
  29. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  30. How to group by a Calculated Field

Leave a Comment