/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 vote247 views1 answer
Take sql dump in to file
SQL
-1 vote285 views1 answer
Utf8_encode mysql
SQL
0 vote276 views1 answer
Set root password mysql xampp
SQL
0 vote264 views1 answer
Mssql now diff 90 day
SQL
3 votes280 views1 answer
Only join in sql
SQL
0 vote268 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote264 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote256 views1 answer
Concat column value of same user in mysql
SQL
0 vote262 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote267 views1 answer
If column value is null then in mysql
SQL