Gossamer Forum
Home : General : Databases and SQL :

SQL query (with date)

Quote Reply
SQL query (with date)
 
SELECT Processed_By as User, COUNT(Processed_By) as Count FROM Data WHERE Processed_Date >= '2004-1-1' And Processed_Date <= '2004-3-2' GROUP BY Processed_By ORDER BY Count DESC;

Doesn't show the statistics between the beginning of this year and yesterday. If I use 2004-3-3 (today) as enddate it works fine. But maybe that this search query can be done easier or more accurate?
Subject Author Views Date
Thread SQL query (with date) cK 4937 Mar 3, 2004, 6:48 AM
Thread Re: [cK] SQL query (with date)
Stealth 4784 Mar 3, 2004, 8:35 PM
Post Re: [Stealth] SQL query (with date)
cK 4700 Mar 3, 2004, 11:25 PM