On Friday, March 24, 2017 at 11:09:11 AM UTC-7, Tom wrote:
>
> hi ,
>
> i have a table item#, posting date.
>
> now i need to know which items have no records within the last 90 days
> (today-90days). not sure how to do that. any ideas?
>
Just FYI, this is a discussion forum for the ruby Sequel library, not a
general discussion for how to use SQL. There's also not nearly enough
information provided to answer your question.
FWIW, using Sequel you can get a list of item numbers that have a positing
date in the last ninety days with something like:
DB[:table].where{posting_date > Date.today - 90}.select_map(:item_number)
But without a source for the full population of item numbers, you cannot
determine what item numbers are not present.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
