MySQL: Sort GROUP_CONCAT values

by

Sure, see http://dev.mysql.com/doc/refman/…tions.html#function_group-concat:

SELECT student_name,
  GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ')
  FROM student
  GROUP BY student_name;

More Related Contents:

  1. GROUP_CONCAT ORDER BY
  2. ORDER BY date and time BEFORE GROUP BY name in mysql
  3. ORDER BY alphabet first then follow by number
  4. Can I concatenate multiple MySQL rows into one field?
  5. MySQL order by before group by
  6. MySQL and GROUP_CONCAT() maximum length
  7. MySQL ‘Order By’ – sorting alphanumeric correctly
  8. What is the opposite of GROUP_CONCAT in MySQL?
  9. MySQL DISTINCT on a GROUP_CONCAT()
  10. Ordering by specific field value first
  11. Using union and order by clause in mysql
  12. Mysql order by specific ID values
  13. What is MySQL row order for “SELECT * FROM table_name;”?
  14. Slow query when using ORDER BY
  15. GROUP_CONCAT with limit
  16. MySQL – Control which row is returned by a group by
  17. MySQL order by “best match”
  18. Order by COUNT per value
  19. MySQL/MariaDB – order by inside subquery
  20. MySQL Order before Group by
  21. How create json format with group-concat mysql?
  22. SQL Order By Count
  23. Returning query results in predefined order
  24. updating columns with a sequence number mysql
  25. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  26. Mysql delete statement with limit
  27. GROUP_CONCAT equivalent in Django
  28. Sort the rows according to the order specified in WHERE IN clause
  29. mysql sorting of version numbers
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment