1:1 관계

SELECT BOARD_NO
        ,BOARD_TITLE
        ,BOARD_CONTENT
        ,BOARD_WRITER
        ,BOARD_DATE
        ,BOARD_SRC
        ,BOARD_LINK
        ,BOARD_HITS
        ,BOARD_TYPE
FROM BOARD
WHERE BOARD_TYPE = 'B02'
ORDER BY BOARD_NO desc
LIMIT {start}, {offset};

• start : 시작할 row
• offset : 보여줄 갯수
• 예: 한화면에 10개씩 보여줄거라면, (0,10) / (10,10) / (20,10) 이렇게 페이지를 누를 때마다 LIMIT의 값이 변해야한다

참고

• https://frog-hindleg.tistory.com/224

1:N 관계

SELECT A.APPLY_NO
	, APPLY_NAME
    , APPLY_PHONE
    , APPLY_EMAIL
    , APPLY_CMMT
    , APPLY_FLAG
    , APPLY_DATE
    , B.APPLY_FILE_NO
    , B.APPLY_FILE_SAVE
    , B.APPLY_FILE_ORG
    , B.APPLY_FILE_SIZE
    , B.APPLY_FILE_MIME
    , B.APPLY_FILE_FANCY

        FROM (SELECT
                  APPLY_NO, APPLY_NAME, APPLY_PHONE, APPLY_EMAIL, APPLY_CMMT, APPLY_FLAG, APPLY_DATE
              FROM APPLY
              ORDER BY APPLY_NO desc
              LIMIT {start},{offset}

             ) A
LEFT OUTER JOIN APPLYFILE B on (A.APPLY_NO = B.APPLY_NO)
ORDER BY A.APPLY_NO DESC, B.APPLY_FILE_NO ASC

참고

• https://stackoverflow.com/questions/9282854/accurate-pagination-with-left-joins