Home > database >  Oracle in accordance with the first week, the week including two months on a monthly basis points ag
Oracle in accordance with the first week, the week including two months on a monthly basis points ag

Time:09-16

I now select date condition the 2019-05-28-2019-05-28 (calendar: 5.27 on Monday,,, on Sunday, 6.02 to 6.03 on Monday,,, 6.09 Sunday), I think the results are: the 2019-05-27-2019-05-27, the 2019-06-01-2019-06-01, the 2019-06-03-2019-06-03

CodePudding user response:

Want to found out the result is what kind of? To a figure

CodePudding user response:

The original data look like?

CodePudding user response:

reference 1st floor ZJHZ_ leaf response:
want to found out the result is what kind of? To a figure

On the back, not the figure,,,, that I delete the first, you reply, I pictured above

CodePudding user response:

refer to the second floor selling fruit net reply:
original data look like?

"Date" every day there are different for different employees, I do report, according to a fixed condition, do statistics, is combined with variable conditions screening record

CodePudding user response:

reference 1st floor ZJHZ_ leaf response:
want to found out the result is what kind of? To a figure

I use this app # CSDN# found have technical content of the blog and friends to seek common to "Oracle weekly points, first week containing two month, then months, and how to write a SQL statement? A great god for help!!!!!! ", gathered together https://bbs.csdn.net/topics/392778096
In the figure

CodePudding user response:

The building Lord said want what is the outcome of the logic

CodePudding user response:

reference week of 6th floor Mricoo_ response:
the original poster said want what is the outcome of the logic of

Please go to the fifth floor to give url corresponding BBS, thank you
  • Related