/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 vote376 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote339 views1 answer
Call procedure in wordpress
SQL
0 vote342 views1 answer
Show create table in postgresql
SQL
2 votes391 views1 answer
How to check if a row is null in sql
SQL
1 vote371 views1 answer
Customer using hdfc bank sql query
SQL
0 vote396 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote328 views1 answer
Oracle list chain steps
SQL
24 votes354 views4 answers
Delete db postgres
SQL
0 vote375 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote382 views1 answer
How to fetch data from database in sql
SQL