sqlserver 分页

发布时间：2020-12-12 14:49:29 所属栏目：MsSql教程来源：网络整理

导读：With ?t? AS ? ( ???? SELECT ?contactid,?namestyle,?lastname, ????ROW_NUMBER()? over ( order ? by ?namestyle)? as ?RowNumber? ???? FROM ?Person.Contact ) select ? * ? from ?t Where ?RowNumber? Between ? 20 ? and ? 30

With ?t? AS ?
(
???? SELECT ?contactid,?namestyle,?lastname,
????ROW_NUMBER()? over ( order? by ?namestyle)? as ?RowNumber?
???? FROM ?Person.Contact
)
select? *? from ?t
Where ?RowNumber? Between? 20? and? 30

（编辑：李大同）

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