2
According to https://forum.imasters.com.br/topic/384021-comando-contr%C3%A1rio-de-distinct/
Edit1: According to this other source http://www.mysqltutorial.org/mysql-find-duplicate-values/ the command below does exactly what you described.
select campo from tabela group by campo having count(*) >1
Edit2: Excuse me, probably the mistake was mine in not showing in practice how this command would be adapted to your case. I suppose it is so:
select setor,count(quantidade) as quantidade, usuario from arquivo coletor group by quantidade having count(quantidade) >1
I don’t know so much about SQL so there won’t be a more theoretical explanation, but I think it would look like this.
Hello @Hugorutemberg. Should the result be the two sector 150 records? Or just one with the sector and the sum of the quantity? Or something else?
– João Martins