Finding duplicate entries

Databases
1

To make it easier to explain my question, here is a sample record set:

pid uid
200 1
201 1
202 1
100 2
101 2
102 2
100 2
101 2
102 2

I want to query a table like this (but with many more records) to find which uids have more than one entry for the same pid, e.g. for the example above, the result would be “2”. I don’t need to know how many duplicates there are, nor what the duplicate pids are. I just need to know which uids have duplicate pids.

Also, unlike the example, the pids are not necessarily sequential.

Is this possible?

2 
SELECT uid
     , pid
  FROM daTable
GROUP
    BY uid
     , pid
HAVING COUNT(*) > 1
3

Awesome! Thanks Rudy, it works perfectly!