Re: count(*)? was: Re: Query Question...

2005-07-16 Thread stipe42
count(distinct column) count NULL as a distinct value or not? I.e. if I've got four records in a table with one column: (null, a, a, b), will count(distinct column) return 3 or 2? stipe42 Nic Stevens wrote: > Hi , > > This is a little off topic but I have seen count(*) on this lis

Re: Query Question...

2005-07-16 Thread stipe42
think the only way to get the sum is to either run a second query, or to sum up the count column in your code as you're looping through the results. stipe42 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]