/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 vote165 views1 answer
Replace null value within column mysql
SQL
0 vote174 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote128 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
1 vote108 views3 answers
Union in sql
SQL
0 vote109 views1 answer
Mysql search like but first exact match
SQL
0 vote110 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
7 votes83 views1 answer
Safe mode mysql
SQL
0 vote148 views1 answer
Cahnge column name apex oracle
SQL
2 votes100 views1 answer
Mysql cannot delete or update a parent row
SQL
2 votes103 views1 answer
Oracle cpu per session
SQL