How to set up a filter for unique values?

Question

MySQL

You want to filter out non-unique values ​​in a table.
There is a table of type
id | name | surname
--------------------
1 | 1595 | 380src2
| 1595 | 380brc
3 | 1596 | 380rcc
4 | 1596 | 380wcc
5 | 1597 | 380rcc
After the filter it should look like this.
id | name | surname
--------------------
1 | 1595 | 380src3
| 1596 | 380rcc
5 | 1597 | 380rcc
Remove duplicates from the "name" column.
There is a similar function in Excel`s - "Only unique records".
Interestingly, I did not find such a function in Navicat and dbForge.
Thank you.

Answer 1

select * from table group by name ?