/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 vote362 views1 answer
Mysql drop vs delete
SQL
1 vote381 views2 answers
Select into temp table
SQL
18 votes308 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote367 views1 answer
Sql upsert
SQL
1 vote389 views1 answer
Primary key with prefix sql
SQL
2 votes351 views1 answer
Postgresql drop primary key constraint
SQL
0 vote368 views2 answers
Postgresql variable in query
SQL
1 vote358 views1 answer
Oracle activate job
SQL
4 votes367 views1 answer
Sql any
SQL
1 vote367 views1 answer
Mysql event last execution
SQL