/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 vote338 views1 answer
Oracle start job
SQL
0 vote398 views1 answer
Get primary key of table
SQL
0 vote331 views1 answer
Postgresql parse json array
SQL
0 vote380 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote384 views1 answer
Set default value now() date
SQL
-3 votes338 views1 answer
Remove spaces sql 2008
SQL
0 vote364 views1 answer
Alter fedora mysql 8.0 user
SQL
1 vote339 views1 answer
Autocommit mysql
SQL
3 votes360 views1 answer
Oracle get trigger ddl
SQL
7 votes363 views2 answers
Mysql default value
SQL