Oracle SQL

一种方法是使用联合：

WITH cte AS (    SELECt "FILE", ID, PARENTID, SHOWCHILD, CAT1, CAT2, CAT3, TOTAL, 1 AS position    FROM yourTable    UNIOn ALL    SELECt 'Tot', 'Res', 'Res', 'N', SUM(CAT1), SUM(CAT2), SUM(CAT3), SUM(TOTAL), 2    FROM yourTable    WHERe SHOWCHILD = 'Y')SELECt "FILE", ID, PARENTID, SHOWCHILD, CAT1, CAT2, CAT3, TOTALFROM cteORDER BY    position,    "FILE";