title: Pulling common IDs using sql query
body: <p>table name : Account</p>
  
  <p>Column : </p>
  
  <pre><code>ParentID      RecordType
  ABC100        X
  ABC100        Y
  EFG100        x
  HIJ200        x
  JKL200        Y
  UVW100        Y
  UVW100        X
  </code></pre>
  
  <p>how can i pull ParentID ABC100 and UVW100? i want to pull only those parentids where i have both X and Y as record type? </p>