Good Morning,
Help, I have a table where I have two columns: articles and bar_code.
I wanted a result that would tell me which articles have more than 1 bar code but only the different ones or +1.
Thank you for your help.
This code don't work:
SELECT artigo,
count(distinct codigo_de_barra) as [Mais de 1]
from tabela
group by artigo
having count(distinct codigo_de_barra) > 1
Thks,
JC
Help, I have a table where I have two columns: articles and bar_code.
I wanted a result that would tell me which articles have more than 1 bar code but only the different ones or +1.
Thank you for your help.
This code don't work:
SELECT artigo,
count(distinct codigo_de_barra) as [Mais de 1]
from tabela
group by artigo
having count(distinct codigo_de_barra) > 1
Thks,
JC