/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

4 votes203 views3 answers
Employee name starting with in sql
SQL
0 vote202 views1 answer
Get the next column of a table in mysql
SQL
0 vote162 views1 answer
How to to get current date and time in sql
SQL
0 vote176 views1 answer
Resulting Query
SQL
4 votes181 views2 answers
Oracle default date format
SQL
0 vote193 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote172 views1 answer
Create or replace view postgress
SQL
0 vote173 views1 answer
How to check if there is no database schema
SQL
0 vote185 views1 answer
Mysql root permission denied lost
SQL
0 vote199 views2 answers
Oracle ora-00054 how to unlock
SQL