假设当前页为第page_current页,每页显示page_size条 当前页显示记录的sql语句为:sql="select top '"+page_size"' * from table where id=? and id not in(select top'"+(page_current-1)*page_size+"'id from table where id=?) order by id desc";
假设当前页为第page_current页,每页显示page_size条 当前页显示记录的sql语句为:sql="select top '"+page_size"' * from table where id=? and id not in(select top'"+(page_current-1)*page_size+"'id from table where id=?) order by id desc";
select top 10 * from table where Num not in(select top 0 Num from table) order by Num desc
order by id descwhere条件,排序条件可以自己变
order by Num desc
当前页显示记录的sql语句为:sql="select top '"+page_size"' * from table where id=? and id not in(select top'"+(page_current-1)*page_size+"'id from table where id=?) order by id desc";
当前页显示记录的sql语句为:sql="select top '"+page_size"' * from table where id=? and id not in(select top'"+(page_current-1)*page_size+"'id from table where id=?) order by id desc";
order by Num desc
演示:http://shop.echai.net/erp,用户名和密码都是:admin,其中修改用户或订单后,都可以刷新父页面