Tricky query

I got a query I am trying to compose. Its complex to me!

I need to create a query where three oldest records with like ky_premise_no is sorted by order_completion date

The DTE and TME (Don't ask why the developers didn't use DATE) will be used to determine the age. The ky_premise_no can be duplicates per unique source_order_nbr. The query would only pull back the three oldest duplicate ky_prem_no and order by order_completion_date.

• --------

  ---

  SOURCE_ORDER_NBR NOT NULL VARCHAR2(30) KY_PREM_NO NOT NULL NUMBER(38) DTE VARCHAR2(8) TIME VARCHAR2(6) DESTINATION_APP_ID VARCHAR2(4) RECORD_TYPE VARCHAR2(1) RECORD_SUB_TYPE VARCHAR2(1) RECORD_FUNCTION VARCHAR2(1) RECORD_SEQUENCE_NBR VARCHAR2(2) WORK_GROUP_ID VARCHAR2(9) WORK_ORDER_NBR VARCHAR2(6) ORDER_COMPLETION_DTE VARCHAR2(8) ORDER_TYPE VARCHAR2(6) ACTION_TAKEN VARCHAR2(12) EMPLOYEE_ID VARCHAR2(8) COMMENTS VARCHAR2(255) LAST_PAY_AMOUNT NUMBER(12,2) LAST_PAY_DTE VARCHAR2(8) BALANCE_DUE NUMBER(11,2) DUE_DTE VARCHAR2(8) DELINQUENT_AMOUNT NUMBER(11,2) NBR_OF_CUTOFFS NUMBER(5) CREDIT_INFO VARCHAR2(12)