关于找纪录的

Question

select * from (select * from table order by time) where rownum=3 or rownum = 4;

Answer 1

select * from (select rownum rn,tablename.* from tablename order by coltime) where rn=3 or rn=4;

Answer 2

zhaoyongzhu(zhaoyongzhu) 不愧是有颗'星'的,说得很对

Answer 3

当然啦，zhaoyongzhu是我师傅http://61.144.28.245/hjc/mycgi/bbs/topic.cgi?forum=9&topic=523&show=0