FROM (

SELECT zip_Code, city, state, row_number() over (partition by zip_Code order by isNull(city), city ASC, isnull(state), state ASC) RN

FROM (

SELECT '02130-1911' zip_Code, 'Jamaica Plain' city, 'MA' state UNION ALL

SELECT '02130-1911' zip_Code, 'Jamaica Plains' city, 'MA' state UNION ALL

SELECT '02130-1911' zip_Code, 'aAKLAND' city, 'MA' state UNION ALL

SELECT '01108-2005', NULL , null UNION ALL

SELECT '02130-1911', 'Jamaica Plain', NULL UNION ALL

SELECT '02138-1557', 'Cambridge' , 'MA' UNION ALL

SELECT '02138-1557', NULL , 'MA' UNION ALL

SELECT '02138-1557', NULL , NULL UNION ALL

SELECT '02370-2509', NULL , 'MA' UNION ALL

SELECT '02370-2509', NULL , 'MA' ) LOCATION) subQ

WHERE RN=1