Hello, I am doing an SQL query on my Firebird server. I made the query using the following syntax:
select ds_produto_servico, count(ds_produto_servico) from tb_produto_servico
group by ds_produto_servico
having
count(ds_produto_servico) > 1
In other words, he is picking up all descriptions of products that are duplicated. But I would like to bring the duplicate product code on the screen. Is it possible?
The code field is: CD_PRODUTO_SERVICO
Thanks.