阅读背景:

Oracle查询不计算星期一...星期日和特定时间特定时间的工作总数?

来源:互联网 

I have a table

我有一张桌子

JobID   Date_of_Completion  Region    day
1        23/05/2016          South    monday
2        23/05/2016           north   monday
3        23/05/2016            north  monday
4        23/05/2016            east   monday
5        22/05/2016          South    sunday
6        22/05/2016           north   sunday
7       22/05/2016            south sunday
8       22/05/2016            east  sunday
.
.
.
..
23        2/05/2016            north  monday
24        2/05/2016            east   monday
25        2/05/2016          South    monday
26        2/05/2016           north   monday
27       2/05/2016            south monday
28       2/05/2016            east  monday      
JobID   Date_of_Comp



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: