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?