<p>I need to return a list of record id's from a table that may/may not have multiple entries with that record id on the same date. The same date criteria is key - if a record has three entries on 09/10/2008, then I need all three returned. If the record only has one entry on 09/12/2008, then I don't need it.</p>

```
```
SELECT id, datefield, count(*) FROM tablename GROUP BY datefield
  HAVING count(*) > 1
```
```