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