select
*
from
(
select
*
from
tablename
order
by
createdate
desc
) aaa
-- 按创建时间倒排序
where
rownum <= 1000;
select
*
from
(
select
*
from
tablename
order
by
createdate
desc
) aaa
-- 按创建时间倒排序
where
rownum <= 1000;
转载于:https://www.cnblogs.com/jycjy/p/7722324.html