I have some duplicates in my data attribute table like you can see below:
I used the following formula
count(1, "Site ID") > 1
based on this question: Identifying duplicate attributes in field using QGIS
But as you can see I have just the duplicate values selected. When I click on any of them in order to delete it, the rest of selected stuff disappears (is deselected).
I am wondering about the option, which would allow me to remove these duplicates by some expression.
A similar problem was considered in these threads:
where the Python approach was suggested.
I personally think, the delete duplicate features Removing overlapping/duplicate polygons in the same layer using QGIS is not the best option here, because I have to base my selection on just one column in the data attribute table. How can I sort it out?