SQL NonDINSTINCT Records?

I know it's possible to get unique records with DISTINCT, but what about the exact opposite? Is there a way to get only records that appear more than once?

If so, can it be done with two fields? Like a non-distinct name and age? Or something like that?

I would imagine that would involve some sort of group by statement where the count of the groups is > 1.

example (I tried this on MS SQL Server 7):

PHP Code:

---

 SELECT CELLNUMBER, INSTR_TYPE, COUNT(CELLNUMBER), COUNT(INSTR_TYPE)
FROM [Cell Equipment Complete]
GROUP BY CELLNUMBER, INSTR_TYPE
HAVING COUNT(CELLNUMBER) > 5 AND COUNT(INSTR_TYPE) > 5 


---