Or:

SELECT

OFFICE_ID = MAX(t.OFFICE_ID),

BINDER_ID = MAX(t.BINDER_ID),

t.BINDER_NO

FROM

(

SELECT

rb.*,

rn = ROW_NUMBER() OVER (

PARTITION BY rb.BINDER_NO

ORDER BY rb.BINDER_NO)

FROM dbo.REV_BINDERS AS rb

) AS t

GROUP BY

t.BINDER_NO

HAVING

MAX(t.rn) = 1;

+-----------+-----------+-----------+

| OFFICE_ID | BINDER_NO | BINDER_ID |

+-----------+-----------+-----------+

| 2101110 | 106 | 265 |

| 2105110 | 108 | 5 |

+-----------+-----------+-----------+