/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

11 votes367 views2 answers
You are using safe update mode
SQL
2 votes342 views1 answer
Possgress drop if exists table
SQL
21 votes350 views3 answers
Sql average
SQL
11 votes357 views1 answer
Mysql order by two columns priority
SQL
0 vote370 views1 answer
Sqlcmd no headers
SQL
0 vote373 views1 answer
Oracle job session
SQL
1 vote382 views1 answer
Mysql last year
SQL
0 vote348 views1 answer
Oracle enable chain
SQL
3 votes394 views3 answers
Create table in SQL Server
SQL
38 votes454 views6 answers
Ubuntu install mysql client
SQL