title: How to see what rows are missing between two select statements in SQLite?
body: <p>I have a single table view that has a group column and a data column (among other columns).  In a particular group, there should be n rows of the same set of text in the same order.  However, I'm finding that in some groups, some rows are missing.  I'd like to query the view so that I can see what rows are missing.</p>
  <p>Concrete example:</p>
  <pre><code>+--------+-------+
  | Group  | Data  |
  +--------+-------+
  | 1      | row 1 |
  | 1      | row 2 |
  | 1      | row 3 |
  | 2      | row 1 |
  | 2      | row 3 |
  +--------+-------+
  </code></pre>
  <p>Group 2 has &quot;row 2&quot; missing, and I'd like that output.  Something like:</p>
  <pre><code>+-------+
  | Data  |
  +-------+
  | row 2 |
  +-------+
  </code></pre>
  <p>Is this possible?</p>