SQL look back

I have data with customer  information i.e. on which data they have purchased anything. Now I want to take those customers who have not purchased anything in the last 60 days. How can I do that in SQL?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi pawan, one possible approach... Select from your customer list and outer join a sub-query containing purchases occurring during the trailing 60 days joined to your customer list on customer_id.

    Say you alias your outer joined table as 'purchases'.  If you GROUP BY customer_id you can use a CASE statement or logic in your WHERE clause to retrieve just the members of your customer list who have no data in the outer joined table of purchases.  

    Reply Like
reply to topic
Like Follow
  • 12 days agoLast active
  • 1Replies
  • 98Views
  • 2 Following

Create A New Discussion

Share your thoughts