All,
ive the below table structure + data:
iam trying to get the SUM OF AGING column based on DISTINCT/unique TASK_COUNTER. it can be easy with CTE/nesting inner query but instead i want to write entire query at the same level with one SELECT stmnt.
Any help is appreciated.
Oracle 12c