/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

2 votes213 views1 answer
Capitalize 1st letter in sql server
SQL
2 votes324 views2 answers
How to DROP a table in mysql
SQL
0 vote262 views1 answer
Mysql default uuid
SQL
0 vote239 views1 answer
MySQL get all previous date record
SQL
1 vote279 views1 answer
How to get alternate records from a table in sql
SQL
0 vote186 views1 answer
Sql beginning of previous month
SQL
9 votes198 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote213 views1 answer
Mariadb maximum left join
SQL
0 vote224 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote215 views1 answer
How to transfer pandas datafra,e to sqlite
SQL