SELECT*FROM(SELECT tt.*, ROWNUM AS rowno
FROM(SELECT t.*FROM table_name t
WHERE apply_date BETWEEN TO_DATE ('20210429','yyyymmdd')AND TO_DATE ('20210429','yyyymmdd')ORDERBY create_time DESC, emp_no) tt
WHERE ROWNUM <=15) table_alias
WHERE table_alias.rowno >=1;