i have table looks this:
name post share comment date -------------------------------------------- sita test data 1 5 2 4 28/4/2015 munni test data 2 5 2 5 27/4/2015 shila test data 3 1 3 1 22/4/2015 ram test data 4 5 0 5 1/4/2015 sam test data 5 4 0 2 2/4/2015 jadu test data 6 1 5 2 30/3/2015 madhu test data 7 5 0 4 10/4/2015 now want result set this:
type name post share comment date ------------------------------------------------------------------------- today sita test data 1 5 2 4 28/4/2015 last 7 days sita test data 1 5 2 4 28/4/2015 last 7 days munni test data 2 5 2 5 27/4/2015 last 7 days shila test data 3 1 3 1 22/4/2015 last 30 days sita test data 1 5 2 4 28/4/2015 last 30 days munni test data 2 5 2 5 27/4/2015 last 30 days shila test data 3 1 3 1 22/4/2015 last 30 days ram test data 4 5 0 5 1/4/2015 last 30 days sam test data 5 4 0 2 2/4/2015 last 30 days jadu test data 6 1 5 2 30/3/2015 last 30 days madhu test data 7 5 0 4 10/4/2015 today must have today's post. last 7 days must have today's post + last 7 day's post. last 30 days column must have post of last 30 days.
a couple of unions different case statements date range work.
