I have identified the 'duplicate records' in a table. Although, I claim they are duplicates, they are but the PK is an identity column - so they are not truly duplicates (but based on the other columns - they are). 

I have this data currently in a table with the following format: 

```
ID -> identity column 
Row -> indicates the sequential row number 
RowNumber -> indicates that two of the rows are identical 

```

for example: 

```
ID    Row      RowNumber
500    1        1000 
501    2        1000 
305    1        1050 
306    2        1050

```

I would like to return just the ID's in a single row for each row number 

For example, the result set of the above would be: 

```
500  501
305  306 

```

Any suggestions?