title: Find all records that match a GROUP BY result HAVING count > 1 in SQLite
body: <p>The GROUP BY and HAVING isn't the hard part. This query results the summary:</p>
  
  <pre><code>SELECT date, account, amount, COUNT(1) AS num
  FROM "transactions"
  GROUP BY date, account, amount
  HAVING num &gt; 1
  </code></pre>
  
  <p>Something like:</p>
  
  <pre><code>date        account    amount  num
  2011-02-07  580416690  -6.4    2
  2011-07-19             -50.0   2
  2011-08-29  2445588    -22.0   2
  2011-12-16  265113334  -0.1    3
  </code></pre>
  
  <p>But I dont want the summary (4 records). I want all the relevant records (so 2 + 2 + 2 + 3 = 9 records). If the GROUP BY was on 1 column, that wouldn't be hard either, but with 3 columns...</p>
  
  <p>How do I get the actual records with those values? 1 query must be possible. Do I need 3 subqueries?</p>