Poll
Question:
filter status data
Option 1: Report studio
votes: 0
Option 2: Date calculation
votes: 1
We have a column status need to filter the data, date of this status associated
need to take the count of status and get the count of last 30 days.
status IN ('c1', 'c2') & count of c1, c2 last 30 days
status date
c1 2001-04-08
c2 2004-01-01
c3 2004-01-02
c4 2005-02-04
Please explain how to accomplish this
here i need to find out count of days between sysdate and date check the null value of date if it is null --> add_months(sysdate, -1)
and find out status count of last 30 days.