Sorry, it was a type

Select tty.telno from tty group by tty.telno having count(*)>1

>hi,
>thank you for reply,
>error message SQL: HAVING clause is invalid
>
>
>>>hi all,
>>>
>>>i try as under to finde the duplicted records, not works any idea
>>>thanks
>>>

>>>CLOSE all
>>>USE tty in 0
>>>m.telno=telno
>>>INDEX on telno TO gg
>>>
>>>SCAN FOR telno==m.telno
>>>  IF FOUND()
>>>     replace typ WITH 1
>>>   ENDIF
>>>ENDSCAN
>>>brow
>>>
>>>

>>>
>>>thanks
>>
>>To locate the duplicates, you can use this code.

>>Select tty.telno from tty group by tty.telno having count(*)