楚落凡塵

select *
from (select i.*, row_number() over(order by ID asc) rank FROM t_purc_file i)
where rank >= 2
AND rank <= 4;