DFShan2017的博客

原创 分段查询6到10条记录

SQL分段查询6到10条记录： 无条件时： select * from (select a1.,rownum rn from (select * from 目标表) a1 where rownum<=10) where rn>=6; 有某条件时： select * from (select b.,rownum rn from (select a.* from 目标表 a order b...