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.