I am using QGIS 3.10.0 A Coruna. I would like to label a building layer with with its building number. However, sometimes I have 2-3 buildings with the same number, and I would like to override the labeling by typing in a SQL-Command asking it to make sure that every value is only used once, and that the label is positioned in the middle of the buildings.
I cannot sum up the building into a multipart, because they have, apart from the building number, different attributes I need to keep. Also, I thought about adding a column, where I use the value just once. The problem is that there are often changes within the project, and with an SQL-Command changes could be done automatically.
Is there a IF CASE WHEN THEN that can solve this problem?