/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 votes347 views2 answers
To date oracle
SQL
6 votes328 views2 answers
Join vs union
SQL
5 votes313 views4 answers
Describe table postgres
SQL
0 vote322 views1 answer
Oracle synonym procedure dblink
SQL
2 votes347 views3 answers
Postgres create view
SQL
2 votes369 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote558 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote357 views1 answer
Drop tables from local database postgres pgadmin
SQL
3 votes357 views1 answer
Sql print all names that start with a given letter
SQL
13 votes332 views2 answers
Sql count distinct group by
SQL