mysql:SELECT * FROM a ORDER BY id DESC LIMIT 20,10
=
sqlserver:select top 10 * from (select top 10 * from (select top 20+10 * from a order by id desc) as b order by id asc) as c order by id desc
这里的desc,asc到底何解呢?不懂!去掉以后好像就不太对了!
=
sqlserver:select top 10 * from (select top 10 * from (select top 20+10 * from a order by id desc) as b order by id asc) as c order by id desc
这里的desc,asc到底何解呢?不懂!去掉以后好像就不太对了!
select top 10 * from (select top 10 * from (select top 20+10 * from a order by id desc) as b order by id asc) as c order by id desc
==============================================================
select top 20+10 * from a order by id desc as b 这里 b是asc的
select top 10 * from b as c 这里c是desc的
是为了求10到20条的asc
最后再desc下,就是反过来排啊
因为sqlserver不支持limit,所以你这样写,但是没必要吧。 。。sqlserver应该有他自己的函数支持 类似的操作啊