Select * from (select doc_no, title, reg_date, movie_flag, view_cnt, att_file1, rownum as rnum From VISUAL_NEWS Where movie_flag='5' and title like '%test%') where rnum >= ? and rnum <=?;