Hi there,

I have this query:

select a.num_part, a.cve_prov, a.cve_impo, a.des_merc

from ctrac_clasif a

where a.num_part = '0630039046';

It yields this results:

NUM_PART CVE_PROV CVE_IMPO DES_MERC

========= ========= ========= ==========

0630039046 3400. 19 CUBIERTA

0630039046 3400. 19 CUBIERTA

As you can see, the two resulting rows are identical. 

Now I run the following aggregate query:

select a.num_part,a.cve_prov,a.cve_impo,COUNT(DISTINCT a.des_merc)

from ctrac_clasif a

where a.num_part = '0630039046'

group by a.num_part,a.cve_prov,a.cve_impo

NUM_PART CVE_PROV CVE_IMPO COUNT

========= ========= ========= ======

0630039046 3400. 19 2

Shouldn't COUNT be equals to 1? There's only one distinct value in the DES_MERC column.

Your help is much appreciated.

Regards,

Eduardo