/SQL/Mysql join column order By and group By

Mysql join column order By and group By

SELECT GROUP_CONCAT( table2.id ORDER BY table2.created_at DESC )
FROM table1 INNER JOIN table2 ON table1.id  = table2.table1_id
GROUP BY
table1.id
ORDER BY
table2.created_at

Similar codes

0 vote276 views1 answer
Ubuntu connect to mssql database
SQL
1 vote283 views1 answer
Continue in sql
SQL
0 vote263 views1 answer
Change data type in mysql
SQL
0 vote261 views1 answer
Sql string contains case sensitive
SQL
0 vote278 views3 answers
Mysql keyword search
SQL
5 votes268 views1 answer
How to use rank function in sql
SQL
2 votes272 views2 answers
How to DROP a table in mysql
SQL
0 vote289 views1 answer
Tinydb add table
SQL
3 votes286 views1 answer
Postgres kill running query
SQL
0 vote260 views1 answer
Number(10 2) in sql means
SQL