SQL NonDINSTINCT Records?

[The Hobo]

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?

[ober0330]

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

[ober0330]

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

 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