title: ORACLE SQL compare two or more rows in same table
body: <p>I have a table with values similar to this</p>
  
  <pre><code>Uname | Grp_ID | Role_ID
  ---------------------
  usr1  | 10     | 1032
  usr1  | 10     | 1034
  usr1  | 20     | 1032
  usr1  | 20     | 1034
  usr1  | 30     | 1032
  usr1  | 40     | 1032
  usr1  | 50     | 1034
  usr1  | 50     | 1034
  usr1  | 60     | 1018
  usr1  | 70     | 1057
  </code></pre>
  
  <p>I want output Grp_IDs which have 1032 and 1034 (both) as the Role_IDs
  For example,</p>
  
  <pre><code>Grp_ID 10 has 1032 and 1034 as ROle_IDs
  Grp_ID 20 has 1032 and 1034 as ROle_IDs
  </code></pre>
  
  <p>Grp_ID 30, 40, 50, 60 ,70 do not have both 1032 and 1034 as Role_IDs</p>
  
  <p>I have tried used inner joins and 'having' but don't seem to get what I want.</p>