oracle 9i 和 sql2005 分页sql代码

 oracle 9i -----string commandText = string.Format(@"select * from (select rownum r_id,Point.* from(select l.point_no,l.point_name,l.address,l.snc_code from POINT_CONNECTION l)Point) AlPoint where 1=1 and r_id between {1}*({0}-1)+1 and {1}*{0} order by point_no asc", nowPage, pageSize);

sql2005  ----string sql = string.Format(@"SELECT * FROM (select *,ROW_NUMBER() Over(order by user_id) as rowNum from UserInfo ) as myTablewhere rowNum between {1}*({0}-1)+1 and {1}*{0} order by user_id asc", nowpage, PageNavigate1.CountPerPage);nowpage当前页码/PageNavigate1.CountPerPage 每页显示多少条