작성일 : 12-11-27 17:01
|
[MsSQL] MSSQL 페이징 ROW_NUMBER
|
 |
|
글쓴이 :
조형래
 조회 : 4,986
|
DECLARE @START_INDEX INT, @END_INDEX INT
SET @START_INDEX = ((@intCurrentPage-1) * 20) + 1
SET @END_INDEX = @intCurrentPage * 20
SELECT ATTENDANCE FROM (
SELECT row_number() OVER (ORDER BY LRNHIS_SEQ ASC) AS ROW_NUM -- 여기에서 순서가 지정됨으로 ORDER BY 가 따로 필요없음
,ATTENDANCE
FROM S_TB_AAAA LH1
INNER JOIN S_TB_XXX_XXX UU1 ON UU1.COMPANY_NO = US1.COMPANY_NO
AND UU1.COM_PRODUCT_YEAR = CONVERT(VARCHAR(4), LA1.LRNAPP_START)
AND UU1.COM_PRODUCT_KISU = LA1.COM_PRODUCT_KISU
WHERE LH1.USER_ID = 'sch_20094463'
) AS FOR_ROW_NUM
WHERE ROW_NUM BETWEEN @START_INDEX AND @END_INDEX
|
|
1758
