Row_Number() 的運用上一筆,下一筆－丫烈客

Apr 13 Thu 2006 18:17
Row_Number() 的運用上一筆,下一筆

close

下一筆

SELECT RowNum,USER_GUID,NAME
FROM   (SELECT USER_GUID,NAME ,         ROW_NUMBER() OVER(ORDER BY USER_GUID) as RowNum
FROM TB_EB_USER   ) as DerivedTableNameW
WHERE RowNum =
(SELECT RowNum
FROM
   (SELECT USER_GUID,ROW_NUMBER() OVER(ORDER BY USER_GUID) as RowNum
    FROM TB_EB_USER
   ) as DerivedTableName
WHERE USER_GUID ='994669d3-822a-40e2-82fc-622b93279386') + 1

上一筆

SELECT RowNum,USER_GUID,NAME
FROM   (SELECT USER_GUID,NAME ,         ROW_NUMBER() OVER(ORDER BY USER_GUID) as RowNum
FROM TB_EB_USER   ) as DerivedTableNameW
WHERE RowNum =
(SELECT RowNum
FROM
   (SELECT USER_GUID,ROW_NUMBER() OVER(ORDER BY USER_GUID) as RowNum
    FROM TB_EB_USER
   ) as DerivedTableName
WHERE USER_GUID ='994669d3-822a-40e2-82fc-622b93279386')  - 1