>>>What numbers do you see for the records that have the same Precinct? The Rn should be the same, if not, then they are not identical.
>>
>>
>>1 through 27 - the same number of precints for that county
>
>I think we may misunderstand each other now. Do you have the same precinct for that county? If you do, do these records have the same Rn number or this number is different?
>
>You said originally that you're seeing duplicates. Did I understand you correctly? With DENSE_RANK() you're not supposed to get duplicates unless they only look like duplicates but not really duplicates. This is what I'm trying to determine now.


They allappear the same to me.

There are multiple precincts in each county, The out put needs to show only aone insance of each precinct in each county. I other words, under the Adams count column each precincnt should only appear once.