| List: | General Discussion | « Previous MessageNext Message » | |
| From: | John Meyer | Date: | September 16 2009 7:51pm |
| Subject: | Datediff function | ||
| View as plain text | |||
I'm trying to pull up a list of users who haven't tweeted in 7 or more days, and I'm trying to use this statement: SELECT USER_NAME, MAX(TWEET_CREATEDAT) FROM USERS NATURAL JOIN TWEETS WHERE DATEDIFF(NOW(),MAX(TWEET_CREATEDAT)) > 7 GROUP BY USERS.USER_ID But it says "invalid group function". How should I reword this query?
| Thread | ||
|---|---|---|
| • Datediff function | John Meyer | 16 Sep |
| • RE: Datediff function | Gavin Towey | 17 Sep |
| • Re: Datediff function | John Meyer | 17 Sep |
| • RE: Datediff function | Gavin Towey | 17 Sep |
| • RE: Datediff function | Jerry Schwartz | 17 Sep |
| • Re: Datediff function | Shawn Green | 17 Sep |
