Posts by Cauan Cardoso • 1 point
1 post
-
0
votes2
answers199
viewsA: How to insert grouped data from one table to another SQL
What you are looking for is a GROUP BY associated with SUBSTRING_INDEX and GROUP_CONCAT functions. In Mysql, you will get something like this: SELECT id, pis, data, SUBSTRING_INDEX(GROUP_CONCAT(hora…