PS Query & SQL

I have an expression that I want to make unique

'INV'|| NEXT_DAY(SYSDATE - 7, 'SUNDAY')||'_'||A.ITEM_TYPE||'_'||A.EMPLID||'_'||ROWNUM

I want it to only have the rownum after it sums up the amount for a student. 

Example student A got a 50.00 scholarship, then another row removed the 50.00 scholarship. So a net of zero. I don't want to show the person who has a net of zero - but by my expression - it gives me every row of data..... 

Is there a way to get what I want from Query Manager? 

------------------------------
Steph Zimmerman
IT Tech Associate
Illinois State University
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Original Message:
Sent: 4/14/2026 3:10:00 PM
From: Steph Zimmerman
Subject: Is there a way.... Rownum sort of

I have an expression that I want to make unique

'INV'|| NEXT_DAY(SYSDATE - 7, 'SUNDAY')||'_'||A.ITEM_TYPE||'_'||A.EMPLID||'_'||ROWNUM

I want it to only have the rownum after it sums up the amount for a student. 

Example student A got a 50.00 scholarship, then another row removed the 50.00 scholarship. So a net of zero. I don't want to show the person who has a net of zero - but by my expression - it gives me every row of data..... 

Is there a way to get what I want from Query Manager? 

------------------------------
Steph Zimmerman
IT Tech Associate
Illinois State University
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------