select * from
(
select rownum xxx,parent from(
select parent from cc_tree order by parent desc
)
) where xxx>=4 and xxx<=8