title: Comparing between rows in same table in Oracle SQL
body: <p>I'm trying to find the best way to compare between rows by CustomerID and Status. In other words, only show the CustomerID when the status are equal between multiple rows and CustomerID. If not, don't show the CustomerID. </p>
  
  <p>Example data</p>
  
  <pre><code>CUSTOMERID        STATUS
  1000              ACTIVE
  1000              ACTIVE
  1000              NOT ACTIVE
  2000              ACTIVE
  2000              ACTIVE
  </code></pre>
  
  <p>RESULT I'm hoping for</p>
  
  <pre><code>CUSTOMERID        STATUS
  2000              ACTIVE
  </code></pre>