/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

5 votes125 views3 answers
Postgres show databases
SQL
18 votes127 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote140 views1 answer
Arithmetic expression in sql
SQL
-1 vote124 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote117 views2 answers
Sql last updated
SQL
1 vote128 views1 answer
Increase existing date in sql
SQL
0 vote117 views1 answer
Sql server inner join convert collation
SQL
5 votes127 views1 answer
Add column table sql default value
SQL
1 vote174 views1 answer
Sqlite show columns in table
SQL
1 vote124 views1 answer
Psql autocomplete for mac brew install
SQL