title: How to select item matching Only IN List in sql server
body: <p>How can one select only the items he want in the IN list? for example</p>
  
  <pre><code>select * from pagetags where TagID in (1,2,4)
  </code></pre>
  
  <p>Now I want all the pages which has all the above 3 IDs assigned to them (1,2,4), not just any of them but all of them?</p>
  
  <p>Is there a way? any other operator? I have already tried <code>= Any</code> and <code>= All</code> but no luck.</p>