/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 vote211 views1 answer
Oracle call a function in a insert statement
SQL
1 vote206 views1 answer
Can not connect to mysql server
SQL
0 vote226 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote215 views1 answer
Android sqlite add column if not exists
SQL
1 vote293 views1 answer
Aqua Data studio postgresql ssl
SQL
4 votes224 views2 answers
Linq join
SQL
0 vote413 views1 answer
How to connect .sql data set to powerbi
SQL
18 votes222 views4 answers
Uninstall mysql on ubuntu
SQL
18 votes178 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote209 views1 answer
Sql file in postgres with pgadmin
SQL