select * from
(select t.num_col x,rownum num from
(select num_col from table_a order by num_col desc ) t ) newt
where newt.num<20 and newt.num>10
(select t.num_col x,rownum num from
(select num_col from table_a order by num_col desc ) t ) newt
where newt.num<20 and newt.num>10