WITH t AS
(
SELECT 1 seq, '00' c2 FROM dual
UNION ALL SELECT 2, '00' FROM dual
UNION ALL SELECT 3, '00' FROM dual
UNION ALL SELECT 4, '00' FROM dual
UNION ALL SELECT 4, '02' FROM dual
UNION ALL SELECT 5, '02' FROM dual
UNION ALL SELECT 5, '00' FROM dual
UNION ALL SELECT 6, '00' FROM dual
UNION ALL SELECT 7, '00' FROM dual
UNION ALL SELECT 8, '00' FROM dual
)
SELECT seq, c2
  FROM (SELECT seq, c2
             , seq - DENSE_RANK() OVER(PARTITION BY cnt ORDER BY seq) gb
          FROM (SELECT seq, c2
                     , COUNT(*) OVER(PARTITION BY seq) cnt
                  FROM t
                )
        )
 ORDER BY MIN(seq) OVER(PARTITION BY gb)
     , c2 DESC, seq
;

 감사합니다 마농님!!! ^^