/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 vote193 views2 answers
Sql insert timestamp
SQL
0 vote197 views1 answer
Exectuer myssql .sql
SQL
-1 vote181 views1 answer
Mysql #1064 error
SQL
0 vote194 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote206 views1 answer
The fetch keyword oracle
SQL
0 vote216 views2 answers
Mysql show foreign keys
SQL
1 vote186 views1 answer
DATE_SUB postgres
SQL
0 vote200 views2 answers
Select last 30 days sql
SQL
0 vote372 views1 answer
Get first match in each group mysql query
SQL
0 vote191 views1 answer
Postgresql extract hour and minutes from timestamp
SQL