/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

-1 vote173 views1 answer
Sql oracle take only last results
SQL
92 votes2.3K views6 answers
Substring
SQL
14 votes186 views4 answers
Online sql compiler
SQL
1 vote162 views2 answers
Mysql show views
SQL
0 vote206 views1 answer
Sql min
SQL
0 vote177 views1 answer
Sql server change schema of a table
SQL
2 votes174 views6 answers
In in sql
SQL
3 votes193 views1 answer
Oracle cannot access v$session
SQL
0 vote230 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
2 votes204 views2 answers
Python escape string for sql
SQL