안녕하세요 오라클에서 아래와 같은 구문으로 페이징을 시도 하였으나 제대로 안되어서 이렇게 글을 남김니다.
1.번
$query="select id,com_name,name,e_mail,tel,hp,domain from ";
$query.="(select m.member_id as id,m.company_name as com_name,m.contact_name as name,m.e_mail as e_mail,m.tel_no as tel,";
$query.="m.hp_no as hp, w.domain_name as domain,rownum as rnum ";
$query.="from n_winc w, n_member m where w.member_id = m.member_id and .status = '110' ";
$query.="order by w.reg_dt desc) where rnum >= 1 and rownum <= 30";
2번
$query="select id,com_name,name,e_mail,tel,hp,domain from ";
$query.="(select m.member_id as id,m.company_name as com_name,m.contact_name as name,m.e_mail as e_mail,m.tel_no as tel,";
$query.="m.hp_no as hp, w.domain_name as domain,rownum as rnum ";
$query.="from n_winc w, n_member m where w.member_id = m.member_id and w.status = '110' ";
$query.="order by w.reg_dt desc) where rnum >= 31 and rownum <= 30";
3번
$query="select id,com_name,name,e_mail,tel,hp,domain from ";
$query.="(select m.member_id as id,m.company_name as com_name,m.contact_name as name,m.e_mail as e_mail,m.tel_no as tel,";
$query.="m.hp_no as hp, w.domain_name as domain,rownum as rum ";
$query.="from n_winc w, n_member m where w.member_id = m.member_id and w.status = '110' ";
$query.="order by w.reg_dt desc) where rnum >= 31 and rownum <= 60";
위와 같이 했을 경우.
1번과 2번의 쿼리 실행시 30개의 실행결과가 나오나 똑같은 결과가 뿌려지며, 3번 실행시 30개만 나오는 것이 아니라 결과가 60개가 나옵니다.
3번 실행시 결과를 30개만 나오게 하려면 어떻게 해야 하는지......
|