如果不需要排序
前5条:sleect * from tbname where rownum<=5;
后5条:select * from (
select * from tbname order by rowid desc)
where rownum<=5;
前5条:sleect * from tbname where rownum<=5;
后5条:select * from (
select * from tbname order by rowid desc)
where rownum<=5;
t.zjjc,t.sjjc,t.finisedwell,t.sjwjs,t.jjs,t.sjjjs,t.jhdate,t.note
from p_gsnjcjh t
order by num desc) a
where num>=(select max(num)-5 from p_gsnjcjh)
and num<=(select max(num) from P_gsnjcjh )
这里根据数据插入的先后顺序来进行排序.并取得最后插入到表中的五行记录
后5条:select * from (
select * from tbname order by rowid desc)
where rownum<=5;
from
(select a.*
from a
order by a.id
) b
where rownum <=5
后5条:select * from (
select * from tbname order by rowid desc)
where rownum<=5;
同意这位兄弟的!