sqlserver 分页

发布时间：2020-12-12 13:34:18 所属栏目：MsSql教程来源：网络整理

导读：1.rowNum select * from? (select *,ROW_NUMBER() over (order by id ) as rowNum from BD_city) as t where t.rowNum between 3*(2-1)+1 ?and 3*2 2.top ?SELECT * FROM ( SELECT TOP 3 * FROM (SELECT ?top 40 * ?FROM? ?(select t1.*,t2.satellite_id ?fr

1.rowNum

select * from?

(select *,ROW_NUMBER() over (order by id ) as rowNum from BD_city) as t

where t.rowNum between 3*(2-1)+1 ?and 3*2

2.top

?SELECT * FROM ( SELECT TOP 3 * FROM (SELECT ?top 40 * ?FROM? ?(select t1.*,t2.satellite_id ?from table1 t1 left join table2 t2)? ?as mm ORDER BY id asc) AS TEMPTABLE1 ? ORDER ? BY id desc)AS TEMPTABLE2 ORDER BY id ASC

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!