GROUP_CONCAT ORDER BY

by

You can use ORDER BY inside the GROUP_CONCAT function in this way: 

SELECT li.client_id, group_concat(li.percentage ORDER BY li.views ASC) AS views, 
group_concat(li.percentage ORDER BY li.percentage ASC) 
FROM li GROUP BY client_id

More Related Contents:

  1. MySQL: Sort GROUP_CONCAT values
  2. Why does MYSQL higher LIMIT offset slow the query down?
  3. How to use GROUP_CONCAT in a CONCAT in MySQL
  4. MySQL ‘Order By’ – sorting alphanumeric correctly
  5. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  6. MySQL Orderby a number, Nulls last
  7. How does MySQL process ORDER BY and LIMIT in a query?
  8. Ordering by the order of values in a SQL IN() clause
  9. Order a MySQL table by two columns
  10. Ordering by specific field value first
  11. MySQL “Group By” and “Order By”
  12. SQL order string as number
  13. What is MySQL row order for “SELECT * FROM table_name;”?
  14. Slow query when using ORDER BY
  15. Select the 3 most recent records where the values of one column are distinct
  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 Order before Group by
  20. How create json format with group-concat mysql?
  21. Returning query results in predefined order
  22. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  23. Mysql delete statement with limit
  24. MySQL – ORDER BY values within IN()
  25. GROUP_CONCAT equivalent in Django
  26. Mysql: Order by like?
  27. Sort the rows according to the order specified in WHERE IN clause
  28. ORDER BY alphabet first then follow by number
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Trouble with GROUP_CONCAT and Longtext in MySQL

Leave a Comment