쿼리를 날리면 seq말구 건 앞에 번호를 붙이고 싶은데 무엇을 하면 될까요? ㅠㅠ
SELECT * FROM(
SELECT
Jnum.*,
FLOOR(((ROW_NUMBER() OVER (ORDER BY reg_date||reg_time desc)) - 1) / 10 + 1) PAGE_NO
FROM(
SELECT
bb.board_seq, bb.title, bb.content, bb.hit, bb.notice_yn,
bb.file_seq, NVL(bb_count.cnt,0) as cr_cnt, bb.reg_id, um.nickname as reg_nickname, bb.reg_date, bb.reg_time,
bb.mod_id, bb.mod_date, bb.mod_time, 'http://192.10.1.82/dcd/image/test.jpg' as user_image,
(CASE bb.reg_id WHEN 'tester' THEN 'Y' ELSE 'N' END) as my_article_yn
FROM BOOKING_BOARD bb, USER_MASTER um,
(SELECT count(*) as cnt, board_seq FROM BOOKING_REPLY GROUP BY board_seq) bb_count
WHERE bb.reg_id = um.user_id(+)
AND bb.board_seq = bb_count.board_seq(+)
) Jnum
)
간단한 쿼리는 위와 같은데 board_seq 말구 순서대로 역순으로 번호를 붙여야해서요..ㅠㅠ |