sinat_33316512的博客

》分页查询6-10的数据： select * from (select rownum rn,t.* from(select id,title,content,occurtime from news order by occurtime desc) t  where rn<=10) where rn>=6;  》连接查询： bookstudent  内连接： Select ...