Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

2850613 Rank 1 - Community Starter

Comments

  • Thank you! This was a huge help. What I did was break the account down into 6 digits and 2 digits. Then, I did a sub-query that listed all accounts ending with '99'. This also had the first 6 digit account. From this sub query, I did another sub query based upon the 6 digit account list in the first sub-query and filtered…