목록마지막글 (1)

DJ메탈짱™의 Free Style

[MS-SQL] 이전글, 다음글, 처음글, 마지막글, Min, Max, Prev, Next (페이징)

-- 이전글 SELECT TOP 1 MEMO_ID, MEMO FROM TB_CMM_MEMO WHERE MEMO_ID = ( SELECT MAX(MEMO_ID) FROM TB_CMM_MEMO WHERE MEMO_ID 9 AND EMPLOYEE_NUMBER = @EMPLOYEE_NUMBER ) -- 마지막글 SELECT TOP 1 MEMO_ID, MEMO FROM TB_CMM_MEMO WHERE MEMO_ID = ( SELECT MAX(MEMO_ID) FROM TB_CMM_MEMO AND EMPLOYEE_NUMBER = @EMPLOYEE_NUMBER ) -- 처음글 SELECT TOP 1 MEMO_ID, MEMO FROM TB_CMM_MEMO WHERE MEMO_ID = ( SELECT MIN(MEMO_ID..
일(job)/DBMS 2016. 1. 14. 15:42
이전 Prev 1 Next 다음