Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create a 'total' row in SQL on Oracle Apex

User_ALXXJMar 18 2022

I am trying to create a Pivot Table on Oracle Apex with a 'total' row on the bottom of the table. This is currently what I have. How am I able to achieve this on SQL.

SELECT
    Committee,
    COUNT(CASE WHEN status = 'Resume Review'    THEN 1 END) AS "Resume Review",
    COUNT(CASE WHEN status = 'Interviewing'     THEN 1 END) AS "Interviewing",
    COUNT(CASE WHEN status = 'Coding Challenge' THEN 1 END) AS "Coding Challenge",
    COUNT(*) AS Total
FROM EMPLOYEES
WHERE status IN ('Resume Review', 'Interviewing', 'Coding Challenge')
GROUP BY Committee;

Any help will be highly appreciated. Thank you!

Comments
Post Details
Added on Mar 18 2022
2 comments
976 views