title: SQLite select all records for which count is greater than 1
body: <p>This is my schema:</p>
  
  <pre><code>create table events(
   event_type integer not null,
   value integer not null,
   time timestamp not null,
   unique (event_type ,time)
  );
  
  insert into events values
  (2,   5,  '2015-05-09 12:42:00'),
  (4, -42,  '2015-05-09 13:19:57'),
  (2,   2,  '2015-05-09 14:48:39'),
  (2,   7,  '2015-05-09 13:54:39'),
  (3,  16,  '2015-05-09 13:19:57'),
  (3,  20,  '2015-05-09 15:01:09')   
  </code></pre>
  
  <p>I would like to display all the records for which <code>event_type</code> has been registered more than once. As you can see in the schema, <code>event_type 2 and 3</code> is occurred more than once. Following is the query I have used which selecting only one record for <code>event_type 2 and 3</code>:</p>
  
  <pre><code>select event_type, value, time from events
  group by event_type
  having count(event_type) &gt; 1;
  </code></pre>
  
  <p>I would like to see the query that would display all the records with <code>event_type 2 and 3</code>. Thanks in advance for all the help.</p>