17,140
社区成员




SELECT x.*
from (SELECT z.*, rownum numbers
from pro_dowload_doc_log z
where rownum <= nextPage
and z.customer_id = ?
and z.dowload_time between to_date(?, 'YYYY-MM-DD HH24:MI:SS') and
to_date(?, 'YYYY-MM-DD HH24:MI:SS')
and z.file_name = ?
and z.customer_doc_num = ?) x
where x.numbers > beforePage;
--你列出具体需求和数据来,只是简单一说,大家不知道你到底要什么效果,用Oracle肯定可以实现,这个放心!