分页方法

来源:互联网 发布:数据集成解决方案 编辑:程序博客网 时间:2024/06/02 15:59
$sql = "select svy_id,subject,type,
                    to_char(create_time,'YYYY-MM-DD HH24:MI:SS') create_time,
                    is_user,class_id,forum_id,msg_id,
                    row_number() over(order by create_time desc) as row_no from survey_new";
            $sql = "select * from (".$sql.") where row_no>=".$begin_no." and row_no<".$end_no;