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.
Subject
Written By
Posted
Re: Get previous 5 days of revenue for each group
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.