In SQL Server 2005 I have a table where I have distinct file names associated with certain personal ID numbers. I want to pull up all of file names where the count of the personal ID's is greater than 1. This is what I'm doing but it's pulling up 0 records:

```
SELECT [file_name], per_ID
FROM mytable
GROUP BY [file_name], per_ID
HAVING COUNT(per_ID) > 1
ORDER BY per_ID, [file_name] ASC

```

I've also tried the following with the same results:

```
SELECT [file_name], per_ID, COUNT(per_ID)
FROM mytable
GROUP BY [file_name],per_ID
HAVING COUNT(per_ID) > 1
ORDER BY per_ID, [file_name] ASC 

```

If anyone can show me what I'm doing wrong I'd appreciate it.

Here's the table structure and data example:

```
file_name | per_ID
9995573157  1111
5996110978  2222
5996111208  3333
8996693000  3333
8996693215  4444
7997617867  5555
9997335346  5555

```

The results I'm looking for would be the file names from per\_ID 3333 and 5555

```
5996111208  
8996693000
7997617867  
9997335346  

```