
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
 
