select *
from (select t.SHEET_NO, t.IF_ASK_AGAIN, t.ORGID, t.OCCUR_TIME
from pre_entry_all_view t
where t.IF_ASK_AGAIN > 0
and t.ORGID = 42
and t.OCCUR_TIME between
to_date('2013-04-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
to_date('2013-04-30 23:59:59', 'yyyy-mm-dd hh24:mi:ss')
order by t.IF_ASK_AGAIN desc)
where rownum <= 10