/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

2 votes196 views1 answer
Postgresql create schema in specific database
SQL
0 vote182 views1 answer
Psql check if value in array
SQL
0 vote189 views1 answer
Sql select with apostrohpe
SQL
0 vote196 views1 answer
Sql server select ignore dupplicates
SQL
0 vote220 views1 answer
Mysql add text to existing field
SQL
0 vote202 views1 answer
Where name ends in SQL
SQL
3 votes193 views1 answer
Sql is not like
SQL
2 votes267 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote244 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote198 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL