/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

3 votes120 views1 answer
Postgresql today - 1 year
SQL
0 vote110 views1 answer
Dump only schema
SQL
3 votes134 views1 answer
Postgres select max value
SQL
2 votes121 views2 answers
Create table mysql integer NOT null
SQL
0 vote140 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote125 views4 answers
Open mysql port bitnami tomact
SQL
0 vote118 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote116 views1 answer
Template MySQL Zabbix agent
SQL
0 vote124 views1 answer
Alter table add check constraint oracle
SQL
0 vote113 views1 answer
Getting next sequence value jpa postgress
SQL