access

1.分页:

                 SELECT top 3 * FROM T_User

           where UserId not in(select top 6 UserId from T_User);//选取数据中前9个中的后三个.

 

2.if(page==1){
   sql="select top "+pageSize+" * from T_User where UserType<>'LEADER'";
  }
  else{
   sql="select top "+pageSize+" * from T_User where UserType<>'LEADER' and UserId not in ";//如果有查询条件,两个都加
   sql+=" (select top "+((page-1)*pageSize)+" UserId from T_User where UserType<>'LEADER')";
  }