hi,
If u have some other fields say for example,
select column1,column2,column3 from <tablename> where ...
and if u add the count(*) with the above query then always remember that you have to add the other fields in the group by clause which will may make the data irrelevant than what you are looking for as the data may be get grouped.
Regards
Felix T