SELECT ID, CNTL_DT, DEVC_TYPE, CNTL_TYPE, RSPS_TYPE FROM TB_RSE_CNTL_HS WHERE CNTL_DT BETWEEN '20140101000000' AND '20141231235959' ORDER BY TO_NUMBER(ID), CNTL_DT
