/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 votes194 views1 answer
Sql delete where in select
SQL
3 votes190 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote191 views1 answer
Mysql select update same table
SQL
45 votes221 views5 answers
Grant all privileges mysql
SQL
0 vote241 views1 answer
Stop and start mysql
SQL
0 vote186 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote187 views2 answers
Mysql join two tables
SQL
0 vote187 views1 answer
How to insert same table data using mysql query
SQL
0 vote192 views1 answer
Sqlplus change user
SQL
3 votes187 views1 answer
Sql multiple column index
SQL