>How i can count many recordes. as this
>in my dbf "c1" and c1 has "20" records. and
> " c2" c2 has"25" records. as .........
>
>in my dbf: c1 to c10 veriabel and c1 to c10 have many record.
>How can count all this
select myColumn,cnt(*) as 'Count' ;
from myTable ;
group by myColumn
myColumn is the field name of your c1...cN values.
Cetin