Count records from previous and current date
Hi all,
From my flag table I would like to count number of records from previous day and count of record from current day on certain columns in a table for example output should look like this:
Flag    ,Previous_Day_Flag     , Current_Day_Flag
Flag1 ,     2,				       1
Flag2,     1,				       2
Flag3,     2 ,                                    100
etc. How can I create a sql statement that will show above.
Flag table
Flag1 etc are NUMBER
FlagDate = DATE