Thank you very Much Sir,
Regards
Harsh
>>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.
Harsh