일기장

#object# 와 연산이 있는 곳은 <![CDATA[ 연산 ]]> 로 묶어줘야 함.

oracle

SELECT * FROM (
	SELECT ROWNUM rn, A.* FROM (
		SELECT board.BOARD_NO,board.BOARD_TYPE_NO, board.CONTENT, board.EMAIL, board.WRITE_DATE
		FROM TB_BOARD board 
		WHERE board.BOARD_TYPE_NO = #type#
		ORDER BY board.WRITE_DATE DESC
		)A
	)WHERE rn >= ((#page#-1)*10)+1 AND rn <= #page#*10
ORDER BY rn

mysql

SELECT T.* 
FROM(
	SELECT @RNUM := @RNUM + 1 AS rn , A.* 
	FROM(
		SELECT email, name, age, date 
		FROM exam.user
		WHERE no < 1020
		order by date desc
	)A,(SELECT @RNUM :=0)R
)T
WHERE rn>=((#page#-1)*10)+1 AND rn <= #page#*10