/SQL/Mysql where in maintain order group_concat

Mysql where in maintain order group_concat

Group_concat in mysql

GROUP_CONCAT(eng_category_name SEPARATOR ',') as eng_category_name

Mysql where in maintain order group_concat

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

Source: stackoverflow.com

Similar codes

1 vote128 views1 answer
How to fetch alternate records from two tables
SQL
0 vote121 views1 answer
Sql select first and last record of each group
SQL
0 vote116 views1 answer
Excel vba import data to sql server
SQL
0 vote118 views1 answer
Do postgresql
SQL
-1 vote125 views1 answer
Search all sql tables for a value
SQL
-1 vote128 views1 answer
Default username and password for oracle 11g
SQL
28 votes113 views4 answers
Mysql delete database
SQL
0 vote124 views1 answer
Postgresql list extensions
SQL
0 vote123 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
9 votes131 views1 answer
Alter table column change data type to text mysql
SQL