Aggregate function in MySQL – list (like LISTAGG in Oracle)

by

You’re looking for GROUP_CONCAT()

Try this:

select group_concat(MyString separator ', ') as myList from table
where id < 4

Of course, you can group by the results.

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. SELECTING with multiple WHERE conditions on same column
  3. MySQL “Group By” and “Order By”
  4. Is there ANY_VALUE capability for mysql 5.6?
  5. SQL Query to get column values that correspond with MAX value of another column?
  6. How to fetch the first and last record of a grouped record in a MySQL query with aggregate functions?
  7. use mysql SUM() in a WHERE clause
  8. MySQL dynamic cross tab
  9. How to select data where a field has a min value in MySQL?
  10. mysql count group by having
  11. Find duplicate records in MySQL
  12. MySQL order by before group by
  13. MySQL Cannot Add Foreign Key Constraint
  14. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  15. Difference between float and decimal data type
  16. Convert timestamp to date in MySQL query
  17. Update a column value, replacing part of a string
  18. Parse date in MySQL
  19. View’s SELECT contains a subquery in the FROM clause
  20. Sort by order of values in a select statement “in” clause in mysql
  21. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  22. ORDER BY date and time BEFORE GROUP BY name in mysql
  23. MySQL INT meaning
  24. MySQL Stored Procedures not working with SELECT (basic question)
  25. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  26. MySQL vs. JSON – Why? [closed]
  27. Should I always prefer MySQL InnoDB over MyISAM?
  28. MySQL add 12 hours to a time field
  29. OSX ld: library not found for -lssl
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment