SELECT cnomres, COUNT(*) FROM mytable GROUP BY cnomres

>
>
>How to count records in a sql clause ?( VFP 9.2 )
>ie Here i want 2 For ncount Value To "GROGNA Denise"
>3 For Houbrechts Anna
>
>How to count a field?
>
>
>Thank in advance and good evening
>
>BHT