-
PL SQl script to get Date when $1million revenue is reached
Hi Experts,
I need help to write a PL SQL script that will show the Date on which a Sales Rep completed a target of $1million sales for a customer account.
However, for some reason,after touching $1 million, if the sales goes down below $ 1 million and then climbs back again then that Date should not be picked.
Table structure can be:
Rep_Code Date Revenue Office_Code
Can someone please suggest.
Thanks,
Prathamesh Acharya
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|