SQL Self joining query
<p>I have a table in the following format.</p>

<pre><code>Id   Orig_Id   Type 
11    1111    Internal
12    1111    Internal
13    1111    Internal
14    1112    External
15    1112    Internal
</code></pre>

<p>I want to retrieve all the Orig_Id's which has "ONLY" the Type as Internal. The query should return 1111.</p>