title: How to check whether all records have the same value in a field?
body: <p>Apologies for the newbie question.</p>
  
  <p>I have data that looks like this:</p>
  
  <pre><code>ID|SubID|Category
  1|1|Fixed
  1|2|Fixed
  2|1|Unfixed
  2|2|Unfixed
  3|1|Fixed
  4|1|Unfixed
  5|1|Fixed
  5|2|Unfixed
  </code></pre>
  
  <p>I need to know all the IDs where the Category is "Fixed" for all SubIDs (i.e. I'd want the query to return IDs 1 and 3).</p>
  
  <p>How can I do this?</p>
  
  <p>An an extension, I need to know all the IDs where the Category contains a mix of "Fixed" AND "Unfixed" for all SubIDs (i.e. I'd want the query to return just ID 5).</p>
  
  <p>Thanks in advance!</p>