MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Adult Canadian Members who haven't accumulated at Company in the past 12 months
Posted by: Keith Larson
Date: April 09, 2014 05:01PM

Well we do not know your table schema but I would usually do it like so

Select individuals from members where country='CA' and acc_score = 'N' and Reg_date <= NOW() - interval 1 YEAR

I assume you want older than 1 year so <= but if you want reg_date in the last year then >=

Just trying to help....

http://anothermysqldba.blogspot.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Adult Canadian Members who haven't accumulated at Company in the past 12 months
Eesa Sandani
April 09, 2014 11:49AM
Re: Adult Canadian Members who haven't accumulated at Company in the past 12 months
Keith Larson
April 09, 2014 05:01PM
Re: Adult Canadian Members who haven't accumulated at Company in the past 12 months
Eesa Sandani
April 09, 2014 05:09PM
Re: Adult Canadian Members who haven't accumulated at Company in the past 12 months
Rick James
April 11, 2014 12:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.