Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Sorabh.

Asked: June 29, 2016 - 8:12 am UTC

Last updated: July 02, 2016 - 6:39 am UTC

Version: 11 g

Viewed 1000+ times

You Asked

Hi,

I want to count records from my database table on every month's 15 days count in respect any group by Id.
Like : GroupBy_Id Count statDate EndDate
5 15 01-Mar-2016 15-Mar-2016
5 2 16-Mar-2016 30-Mar-2016
8 6 01-May-2016 15-May-2016
8 21 16-May-2016 31-May-2016
8 16 01-Jun-2016 15-Jun-2016
8 16 16-Jun-2016 30-Jun-2016

Updated Question:

Sorry, I am not able provide script to you and you could create table in which we have some multiple dates and we just want to every month 15 days count. If month is 'February' so we will count its first 15 days count then we count its remaining days (16 feb to 28 feb).


and Connor said...

Please give us a

- create table script
- some insert statements

so we have the SOURCE data which will generate the result have provided above. Otherwise we dont have anything to work with.

=======================

"Sorry, I am not able provide script to you ...."

Seriously ?

That leads me to say

"Sorry...if you're not prepared to put in a little effort to help us...then we're probably not inclined to help you"


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

:O

John, July 01, 2016 - 11:15 am UTC

Connor could you also make me a cup of coffee please? Milk, no sugar, thanks.
Connor McDonald
July 02, 2016 - 6:39 am UTC

Indeed :-)