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