--- rick <[EMAIL PROTECTED]> wrote: > i'm still getting inconsistenct overall counts. i > have 2117493 records and > this should be my overall total. > > > -- get per hour breakdown > select hour(t_time) as a, count(distinct column1) > from am group by a; > > -- get per month breakdown > select month(d_date2) as a, count(distinct column1) > from am group by a;
Don't use DISTINCT. For what you are asking a 'SELECT a, count(*) FROM x GROUP BY a' should suffice. --- mike t. Send instant messages to your online friends http://uk.messenger.yahoo.com _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
