Noob query
From: Bint <bint_at_ign.com>
Date: Wed, 07 Jan 2015 16:06:35 -0600
Message-ID: <D0D30A0B.FAFF%bint_at_ign.com>
Hello,
Date: Wed, 07 Jan 2015 16:06:35 -0600
Message-ID: <D0D30A0B.FAFF%bint_at_ign.com>
Hello,
I'm pretty new to mySQL. If I have a table with these fields:
userid date action
How would I form a query to count the number of records within the past hour
with different userids? That is, I want to find out how many unique users
are active in the past hour.
I know how to count all the active records in the past hour:
SELECY count(*) FROM records WHERE date >= DATE_SUB(NOW(),INTERVAL 1 HOUR)"
But I want the number of unique user id's in that list. I could get the
Thanks Received on Wed Jan 07 2015 - 23:06:35 CET