By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab (
Name VARCHAR(20),
Mark INT
);
INSERT INTO tab VALUES
('Jack', 12),
('Jack', 12),
('Jack', 4);
SELECT
Name,
GROUP_CONCAT(Mark SEPARATOR ',') AS Marks
FROM
tab
GROUP BY
Name
| Name | Marks |
|---|---|
| Jack | 12,12,4 |