select cho_address, cho_state from tbl_CHO_Operators cho where cho_segmentId in ( 2,3,4,5,16,23,29,30,36,37 ) group by cho_address, cho_state having count( cho_id ) > 1 select cho_id from tbl_CHO_Operators where cho_address = and cho_state =