SELECT B.AGENCY, SUM(B.NUM_LOGIN) FROM GOVAGENCY B WHERE AGENCY = 'DOD2' GROUP BY B.AGENCY) group by ROLLUP( AGENCY) ; The results are:
確定! 回上一頁