Sql query bring repeated result

Question

How do I list only the sector column that has repeated data? in case, just show the sector 150

SELECT setor,count(quantidade) as quantidade, usuario 
FROM arquivo_coletor 
GROUP BY setor,usuario 
ORDER BY setor ASC

Answer 1

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.

Answer 2

If you wish to obtain only those records, with sum of quantity, whose key setor + usuario has duplicates, can use the following solution:

SELECT      setor
        ,   SUM(quantidade) AS quantidade
FROM        arquivo_coletor
GROUP BY    setor
HAVING      COUNT(distinct setor + usuario) > 1

The records grouped by setor and usuario:

SELECT      AC.setor
        ,   AC.usuario
        ,   SUM(ac.quantidade) AS quantidade
FROM        arquivo_coletor AC
INNER JOIN  (
                SELECT      setor
                        ,   SUM(quantidade) AS quantidade
                FROM        arquivo_coletor
                GROUP BY    setor
                HAVING      COUNT(distinct setor + usuario) > 1
            )               AC2 ON AC2.setor = AC.setor
GROUP BY    AC.setor
        ,   AC.usuario

Answer 3

Give a select in all fields and group by them, after a having Count>1

  select setor,quantidade,usuario 
     from arquivo_coletor
    group by setor,quantidade,usuario 
    having count(*) >1