select top 頁大小 *

  from table1

  where id<=

  (select min (id) from

  (select top ((頁碼-1)*頁大小) id from table1 order by id desc) as T

  ) 

  order by id desc

String sql=" from t_Product where 1=1 and ";

  String ProductName = request.getParameter("ProductName");

  if (ProductName!=null) sql=sql+"ProductName like '%" + ProductName + "%' and " ;

  sql=sql.substring(0,sql.length()-4);  // 去掉尾部的 and 字符串

  sql="select top " + String.valueOf(intPageSize) + " *" +sql+" and id <=(select min(id) from (select top " +  String.valueOf(intPage*intPageSize) + " id " + sql + " order by id desc) as T) "; //通過子查詢加快速度

  sql=sql+" order by id desc ";