안녕하세요..

밑에 쿼리는... 부서별로 구룹바이한것입니다.

맨마지막 로우에 총계를 보여 주는거거든요.

근대 문제는.. 소팅을 하면 .. 총계가 위로 올라온다 입니다;

소팅을 어덯게 하든 맨 밑으로 내릴순 없나요?

버전은 2005 입니다...

SELECT * FROM
(
 SELECT      DUTY_AREA                                                                                        
            ,REQ_DEPT_NM                     
            ,COUNT(IT_SUPRT_REQ_DOC_MET_ID)    AS  IT_SUPRT_REQ_DOC_MET_ID                                 
  FROM       ADHOC_IT_SUPRT_REQ_DOC_DTL                                                                       
  WHERE      1=1
  GROUP BY   DUTY_AREA                                                                                        
            ,REQ_DEPT_NM
UNION ALL

SELECT    TOP 1 '전체합계',' ', SUM(IT_SUPRT_REQ_DOC_MET_ID) OVER () TOTCNT FROM
(

 SELECT      DUTY_AREA                                                                                        
            ,REQ_DEPT_NM                                                     
            ,COUNT(IT_SUPRT_REQ_DOC_MET_ID)    AS  IT_SUPRT_REQ_DOC_MET_ID
  FROM       ADHOC_IT_SUPRT_REQ_DOC_DTL                                                                       
  WHERE      1=1
  GROUP BY   DUTY_AREA                                                                                        
            ,REQ_DEPT_NM
 )  AS A
) AS B
--ORDER BY REQ_DEPT_NM ASC  --  
--ORDER BY IT_SUPRT_REQ_DOC_MET_ID DESC  ---