원본 데이터도 올려주세요.

with t (data) as (
select 'TEST01' from dual union all
select 'TEST01' from dual union all
select 'TEST01' from dual union all
select 'TEST02' from dual union all
select 'TEST02' from dual)
select dense_rank() over(order by data)  gp
      , count(data) over(partition by data) group_sum
      , data
from t;

SELECT
       DENSE_RANK() OVER ( ORDER BY T.data ) AS group
      , COUNT(*) AS groupSum      
      , data
FROM TABLE T
group by data
;

그룹의 총 합계라는게 해당 그룹에 포함되어 있는 DATA의 수량 이라면 위와 같이 하시구요..

다른 뜻이라면 정확히 어떤 뜻인지요?

WITH TEST AS (

SELECT 'TEST01' AS DATAS FROM DUAL UNION ALL

SELECT 'TEST01' AS DATAS FROM DUAL UNION ALL

SELECT 'TEST01' AS DATAS FROM DUAL UNION ALL

SELECT 'TEST02' AS DATAS FROM DUAL UNION ALL

SELECT 'TEST02' AS DATAS FROM DUAL 

)

SELECT 

DENSE_RANK() OVER (ORDER BY TATAS ) AS GROUP

,'' AS GROUP_SUM

,DATAS

FROM TEST

지금 짠 쿼리가 저런 형태입니다

딱 저상황일때..... COUNT낼수 없나요??

창조의 날개님이 달아주신것은 그룹바이를 해야되서요;; ㅠㅠ

그룹섬이니까 무조건그룹바이를 해야되나요??