Oracle分页的时候涉及的一个函数
<?php
function get_limit_sql($sql,$min,$max){
return "SELECT * FROM ( SELECT row_.*,rownum rownum_ FROM ($sql) row_ where rownum <=$max) where rownum_>$min";
}
?>
<?php
function get_limit_sql($sql,$min,$max){
return "SELECT * FROM ( SELECT row_.*,rownum rownum_ FROM ($sql) row_ where rownum <=$max) where rownum_>$min";
}
?>