Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE employee
(
department VARCHAR(50) NOT NULL,
salary INT 
);
INSERT INTO employee
VALUES ('Sales', 5000);
1 rows affected

INSERT INTO employee
VALUES ('HR', 6000);
1 rows affected

INSERT INTO employee
VALUES ('IT', 7500);
1 rows affected

INSERT INTO employee
VALUES ('Marketing', NULL);
1 rows affected

INSERT INTO employee
VALUES ('Finance', 5500);
1 rows affected

INSERT INTO employee
VALUES ('Sales', 8000);
1 rows affected

SELECT *
FROM employee


DEPARTMENT
SALARY


Sales
5000

HR
6000

IT
7500

Marketing
null

Finance
5500

Sales
8000


SELECT COALESCE (department, '總計') AS Department,SUM(salary) AS Salary_Sum
FROM employee
GROUP BY ROLLUP (department)


DEPARTMENT
SALARY_SUM


Finance
5500

HR
6000

IT
7500

Marketing
null

Sales
13000

總計
32000