Error in counting number of records!!!

Hanen

Hello,

I have a : select columnA, count(*) number from matable group by ColumnA
The result is an error message "Arithmetic overflow error converting expression to data type int." how can I resolve that problem

Thanks for your help

kapamarou

Should you type select count(*) from "tableName" ? :-k

Hanen

Yes I have to.
But I found how to do it I've replaced the count(*) with Count_Big(*) and that's good I have the result I want :P