[DATABASE/SQLSERVER] ROW_NUMBER 함수 사용하기

■ ROW_NUMBER 함수를 사용하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    ROW_NUMBER() OVER (ORDER BY A.DateTimeWritten DESC, A.DateTimeCreated DESC) AS RowNumber
   ,A.ID              AS ID
   ,A.DateTimeWritten AS DateTimeWritten
   ,A.DateTimeCreated AS DateTimeCreated
   ,A.[FileName]      AS [FileName]
   ,A.FileExtension   AS FileExtension
FROM
(
    SELECT
        A.ID              AS ID
       ,A.DateTimeWritten AS DateTimeWritten
       ,A.DateTimeCreated AS DateTimeCreated
       ,A.[FileName]      AS [FileName]
       ,A.FileExtension   AS FileExtension
    FROM  PhotoBook AS A WITH(NOLOCK)
    WHERE A.MenuID       = 44
    AND   A.CategoryName = '자연'
) AS A;

SELECT

ROW_NUMBER() OVER (ORDER BY A.DateTimeWritten DESC, A.DateTimeCreated DESC) AS RowNumber

,A.ID AS ID

,A.DateTimeWritten AS DateTimeWritten

,A.DateTimeCreated AS DateTimeCreated

,A.[FileName] AS [FileName]

,A.FileExtension AS FileExtension

FROM

(

SELECT

A.ID AS ID

,A.DateTimeWritten AS DateTimeWritten

,A.DateTimeCreated AS DateTimeCreated

,A.[FileName] AS [FileName]

,A.FileExtension AS FileExtension

FROM PhotoBook AS A WITH(NOLOCK)

WHERE A.MenuID = 44

AND A.CategoryName = '자연'

) AS A;