Get first record when all fields are identical except ID and Timestamp?
<p>Here is my current query:</p>

<pre><code>SELECT  TOP 6 *
FROM    HS_IHE_ATNA_Repository.Aggregation
WHERE   EventType = 'Retrieve Document Set'
</code></pre>

<p>It returns data that looks similar to this:</p>

<pre><code>ID     TimeStamp    tid    Fruit      Color       User     EventType
1      12:30:31     001    Apple      Red         Paul     Retrieve Document Set
2      12:30:32     001    Apple      Red         Paul     Retrieve Document Set
3      12:31:03     002    Orange     Orange      Steve    Retrieve Document Set
4      12:31:04     002    Orange     Orange      Steve    Retrieve Document Set
5      12:34:12     003    Banana     Yellow      Paul     Retrieve Document Set
6      12:34:13     003    Banana     Yellow      Paul     Retrieve Document Set
</code></pre>

<p>I would like my query to only return records 1, 3 and 5.  Essentially, everything with a unique tid.  How can I do this?</p>