내용

글번호 1173
작성자 허진경 (나자바바)
작성일 2022-12-27 16:21:21
제목 3중 쿼리를 OFFSET~FETCH 절로 수정하기
내용 SELECT board_id AS "boardId", category_id AS "categoryId", writer AS "writer", email AS "email", title AS "title", write_date AS "writeDate", master_id AS "masterId", reply_number AS "replyNumber", reply_step AS "replyStep", read_count AS "readCount" FROM board WHERE category_id=#{categoryId} ORDER BY master_id DESC, reply_number, reply_step OFFSET #{start}-1 ROWS FETCH FIRST 10 ROWS ONLY