Select nonDistinct?

Hi all,

My first question to the group.

I know that I can use Select Distinct ... to return non-duplicate rows in a table, but is there any way to bring back only the rows that are duplicated. By this I mean, suppose my table looks something like this:

id_number     name
1             Lou da Silva
2             Fred da Silva
1             Alan da Silva
3             Figaro da Silva
4             Felix da Silva
2             Pendejo da Silva

SELECT DISTINCT Id_Number FROM Dasilva_Table;

will bring back

id_number
1
2
3
4

What I would like to do is something like this:

SELECT NONDISTINCT Id_Number FROM Dasilva_Table;

and get back:

id_number
1
2

Thanks in advance and thanks for all the help you've provided indirectly to me by replying to other people's questions. Received on Fri Sep 08 2000 - 23:05:53 CDT