게시판 내용, 카운트 한번에 가져오는 SQL

SELECT BB.* 
FROM (
    SELECT AA.*,ROWNUM RO 
    FROM (
        SELECT   A.seq_no
                 , B.user_nm
                 , COUNT (*) OVER (PARTITION BY NULL) TOTAL
        FROM     AA A
                 , BB B
                 , CC C
        WHERE    A.user_id = B.User_Id
        AND      A.Proc_Stat_Cd = C.COMM_DTL_CD
        AND      A.User_Id = ?
        ORDER BY A.SEQ_NO DESC
      )AA
    )BB
WHERE BB.RO > ? AND BB.RO <= ?