MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t
AS
          SELECT 1 AS Id,    'A' AS Name      ,'A_data_1' AS Other_columns
UNION ALL SELECT 2    ,'A'       ,'A_data_2'
UNION ALL SELECT 3    ,'A'       ,'A_data_3'
UNION ALL SELECT 4    ,'B'       ,'B_data_1'
UNION ALL SELECT 5    ,'B'       ,'B_data_2'
UNION ALL SELECT 6    ,'C'       ,'C_data_1'








Records: 6  Duplicates: 0  Warnings: 0


SELECT * FROM t


Id
Name
Other_columns


1
A
A_data_1

2
A
A_data_2

3
A
A_data_3

4
B
B_data_1

5
B
B_data_2

6
C
C_data_1


SELECT GROUP_CONCAT(id ORDER BY id DESC LIMIT 1) AS id,
       name,
       GROUP_CONCAT(Other_columns ORDER BY id DESC LIMIT 1) AS Other_columns
FROM t
GROUP BY name


id
name
Other_columns


3
A
A_data_3

5
B
B_data_2

6
C
C_data_1

Id	Name	Other_columns
1	A	A_data_1
2	A	A_data_2
3	A	A_data_3
4	B	B_data_1
5	B	B_data_2
6	C	C_data_1