oracle sql. I created a field using this trunc(sysdate) - trunc(EVENT_DT) as TotalDays, I have tried different things and none work. Can you help with syntax to do this?
In the where statement I want only get the days >10
and TotalDays > (10)
ORA-00904: "TOTALDAYS": invalid identifier
00904. 00000 - "%s: invalid identifier"
Error at Line: 40 Column: 5