How to track down doubloons in valentina ?

[olivier]

Hi Ruslan and list,

> No.
>
> There general operation is GROUP BY, DISTINCT,
> Which can compare order remove THE SAME values.

I always study the problem for the doubloons of names of company but 
the example of Beatrix is interesting.
It can be applicable for the family names.

For example, if I want to make a search for doubloons on the name, zip, 
city:

SELECT * FROM Customers GROUP BY Name, Zip, City HAVING COUNT(*)>1

It's good, simple and fast.

It is damage that Valentina 1 does not understand ' HAVING '.

There a trick for to obtain the same result but without HAVING?

thank you

olivier