SSN, Name, Amt
I am trying to find duplicate SSN but my query keeps returning none. I have tried the following but to no avail, it doesn't return any rows:SELECT MAX(Prodti.p_name), MAX(Prodti.p_amt), COUNT(Prodti.p_ssn); FROM ; ti!prodti; GROUP BY Prodti.p_ssn, Prodti.p_name, Prodti.p_amt; HAVING COUNT(Prodti.p_ssn) > ( 1 ); ORDER BY Prodti.p_ssnand also
SELECT MAX(Prodti.p_name), MAX(Prodti.p_amt), Prodti.p_ssn, count(*); FROM ; ti!prodti; GROUP BY Prodti.p_ssn, Prodti.p_name, Prodti.p_amt; HAVING count(*) > ( 1 ); ORDER BY Prodti.p_ssnCan someone tell me what I am missing here. I am using VFP8 by the way.