MYSQL:
select * from (select * from (select * from category order by cat_id limit 20 ) as A order by cat_id Desc limit 10) as B order by cat_id
大家能帮我解释下吗?
下面这种写法运行时不正确
"select * from users where userId not in(select userId from users limit 0,"+pageSize*(pageNow-1)+")limit 0,"+pageSize+""谢谢大家的帮助
select * from (select * from (select * from category order by cat_id limit 20 ) as A order by cat_id Desc limit 10) as B order by cat_id
大家能帮我解释下吗?
下面这种写法运行时不正确
"select * from users where userId not in(select userId from users limit 0,"+pageSize*(pageNow-1)+")limit 0,"+pageSize+""谢谢大家的帮助
n代表每页的数量
pagen也就是页数减去一,代表先排除前n*(页数-1)条,然后再此基础上top n 代表查到n条为止,这样就很好的控制了每页的数量,pagen这个变量很关键