SQL Server 2005 中 ROW_NUMBER()的用法
摘要：
SELECT * FROM(SELECT ROW_NUMBER() OVER(ORDER BY RecordId) AS RowID,* FROM BaseUser) as table1WHERE RowID BETWEEN 20 AND 30-- RowID 将SELECT ROW_NUMBER() OVER(ORDER BY RecordId) 查出的结果取个别名,用于取结果记录的条件[即: ... 阅读全文
posted @ 2010-01-29 11:40 bicabo 阅读(340) 评论(0) 推荐(0) 编辑
