/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

0 vote247 views1 answer
SQL server select to get sum of hours
SQL
45 votes346 views5 answers
Grant all privileges mysql
SQL
0 vote285 views1 answer
Kill a pid redshift
SQL
0 vote269 views1 answer
How to query all tables mysql at the same time
SQL
10 votes339 views4 answers
Join multiple tables in sql
SQL
1 vote286 views1 answer
Sql server epoch to datetime
SQL
5 votes291 views1 answer
Dbms_metadata.get_ddl table
SQL
2 votes310 views2 answers
Oracle create table if not exists
SQL
0 vote284 views1 answer
Subquery aggregation
SQL
4 votes265 views1 answer
Mysql insert from local csv
SQL