More with SQL Server 2005 : Top n Per Group, Paging, and Common Table Expressions
declare @startrow int
declare @endrow int
set @startRow = 40
set @EndRow = 70
with MasterRowNums as
(
select m.nameLast, m.nameFirst, m.lahmanID,
ROW_NUMBER() over (order by m.nameLast, m.nameFirst, m.lahmanID) as RowNum
from [master] m
)
select
MasterRowNums.*
from
MasterRowNums
where
RowNum between @startRow and @endRow
order by
nameLast, NameFirst, lahmanID
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7667023/viewspace-1007478/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
-
博文量25
-
访问量170884
最新文章
- Scheduling Jobs in SQL Server Express
- Create database sample
- how to decrypt an encrypted stored proc in 2005
- The Curse and Blessings of Dynamic SQL
- 日记传送
- Transact-SQL Query Performance Tuning Tips
- Concatenating row values in Transact-SQL
- Ranking data in Transact SQL
- Dynamic SQL CrossTab Stored Procedure ---it very useful
- Essential SQL Server Date, Time and DateTime Functions
