>I have a table which contains two columns namely
>
>attribute(c)
>Accountno (n)
>
>The data is as follows
>
>Attribute Accountno
>
>GOOD 12345256
>GOOD 12345256
>GOOD 12345256
>GOOD 67569856
>FAIR 65957514
>FAIR 65957514
>AVG 99628522
>AVG 65957514
>AVG 12345256
>
>
>In the above table you could see that the account number 12345256 has repeated attribute for GOOD for 3 times. Similarly account Number has FAIR for two times.
>
>For my program, I need to have an attribute for only one time.
>So I need an SQL that could trace the repeated values of an attribute if the account number is same.
SELECT ;
Accountno ;
, Attribute ;
, COUNT( * ) AS DupCount ;
FROM MyTable ;
INTO CURSOR Duplicates ;
GROUP BY Accountno, Attribute ;
HAVING DupCount > 1
Research GROUP BY and HAVING clauses in standard SQL to see how this works.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up