title: Exclude first row from group
body: <p>I am trying to create a table with the cod number (REC_NUM) of all rows where is repeating columns ACCIDENT_REC_NUM and VEHICLE_REC_NUM. So I need to get the code from all rows that can be grouped by this two field.</p>
  
  <p>This part is all right, you can check it by this query:</p>
  
  <pre><code>SELECT COUNT(REC_NUM)  FROM SEQUENCE_EVENT WHERE ACCIDENT_REC_NUM IN (
    SELECT ACCIDENT_REC_NUM
    FROM (
      select ACCIDENT_REC_NUM, VEHICLE_REC_NUM, COUNT(*) AS REPEAT  from SEQUENCE_EVENT
      GROUP BY ACCIDENT_REC_NUM, VEHICLE_REC_NUM
    )
    WHERE REPEAT &gt; 1
  )
  </code></pre>
  
  <p>So, now I have to exclude the first line of each group, because I just need the REC_NUM of the rows that are repeating, so the first one is ok.</p>