mssql 이전글 다음글 쿼리

  SELECT

        A.(게시글 num)

        ,A.(게시글 Title)

        ,T.Next_title
        ,T.Previous_title

   FROM
   테이블명 AS A,

        (select TOP 100000
                A.(게시글 num) AS num,
                A.(게시글 Title),
                LAG(A.(게시글 Title) ,1, NULL) OVER(A.(게시글 CreateDate) DESC)as Next_title,
                LEAD(A.(게시글 Title),1, NULL) OVER(A.(게시글 CreateDate) DESC)as Previous_title

         from 테이블명

        where (1=1)
        order by A.(게시글 CreateDate) DESC
        )as T

  WHERE
  (게시글 num) = @(게시글 num) AND

  T.num=@(게시글 num)