Yes that what i am looking for but wiht rownum if i use order by clause it will change the results.