SELECT        SEQ  ,S_DATE_TXT,S_DATE, EMP_NO, LATE_HOURE, LATE_MNIT, ILLEGAL_EXIT, NO_SIGN, ABSENCE, EMP_NAME, DPT_DESC, USER_EDIT, DATE_EDIT

FROM            ATTENDANCE

WHERE        (TRUNC(S_DATE) BETWEEN TO_DATE(:fromdate, `DD-MM-YYYY`) AND TO_DATE(:todate, `DD-MM-YYYY`)) AND (EMP_NO = :emp_no)

ORDER BY SEQ  DESC