SELECT
rb.OFFICE_ID,
MAX(rb.BINDER_ID),
MAX(rb.BINDER_NO)
FROM dbo.REV_BINDERS AS rb
GROUP BY
rb.OFFICE_ID
ORDER BY
rb.OFFICE_ID;
+-----------+------------------+------------------+
| OFFICE_ID | (No column name) | (No column name) |
+-----------+------------------+------------------+
| 2101110 | 266 | 106 |
| 2105110 | 6 | 108 |
+-----------+------------------+------------------+
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi