select stud_id , group_concat(paper_id) as i from tb group by id Original Table: stud_id paper_id 1 1 1 2 1 3 1 4 2 2 2 3 3 1 4 2 Output: stud_id paper_id 1 1,2,3,4 2 2,3 3 1 4 2… more →
Selectallwrote 4 months ago: select stud_id , group_concat(paper_id) as i from tb group by id Original Table: stud_id paper_id 1 … more →