Hi Guru,
Great day is today.
I want to print out the count based filter in where clause
select count(*) from mytable where SYS_CREATED_ON > SYSDATE-&N;
here, N -> number of days before. Let say 3;
What I want
SYS_CREATED_ON CNT
10_JAN_2023 210524
09_JAN_2023 112568
08_JAN_2023 546783
Thanks