Hi All,
I am looking for a help in knowing if below function syntax works in Oracle. I only need to know, if any version of Oracle supports these combinations of functions.
1) sign(count(request_id)) as 'Customer'
2) (COUNT(SESSION_ID) - sum(is_open)) as 'CLOSED'
-The values of is_open is from case statement as below:-
case VERDICT
WHEN 0 THEN 1
ELSE 0
END is_open
Sorry, for keeping this question too short with too less information. Please note, the above syntax works good in MSSQL Server