MySQL Forums
Forum List  »  General

Re: Get previous 5 days of revenue for each group
Posted by: E C
Date: January 11, 2018 03:34PM

let me clarify, 5 days since the most recent activity.

For example, for ‘Keaton’, the most recent activity was '2010-04-25', therefore it would sum up the revenue from '2010-04-20' to '2010-04-25'


> i can't find a website that supports 'LIMIT & IN/ALL/ANY/SOME subquery'

i'm not sure how to build a database. i just used https://sqltest.net/ and modified the sample code and quickly constructed these rows to do a question given in a test.

Options: ReplyQuote


Subject
Written By
Posted
Re: Get previous 5 days of revenue for each group
E C
January 11, 2018 03:34PM


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.