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