Query to return all results except for the first record
<p>I have a archive table that has records of transactions per locationID.</p>

<p>A location will have 0, 1 or many rows in this table.</p>

<p>I need a SELECT query that will return rows for any location that has more than 1 row, and to skip the first entry.</p>

<p>e.g.</p>

<p><strong>Transactions table</strong></p>

<pre><code>transactionId  locationId  amount
1              11          2343
2              11          23434
3              25          342
4              32          234
5              77          234
6              11          38938
7              43          234
8              43          1235
</code></pre>

<p>So given the above, since the locationID has multiple rows, I will get back all rows except for the first one (lowest transacton_id):</p>

<pre><code>2              11          23434
6              11          38938
8              43          1235
</code></pre>