1/2+1/6+1/12+1/20+1/30+1/42+1/56+1/72
=1/2+(1/2-1/3)+(1/3-1/4)+(1/4-1/5)+(1/5-1/6)+(1/6-1/7)+
(1/7-1/8)+(1/8-1/9)
=1/2+1/2-1/3+1/3-1/4+1/4-1/5+1/5-1/6+1/6-1/7+1/7-1/8+
1/8-1/9
=1-1/9
=8/9
这个应该是一个查询,当开始日期不为空的时候开始查询between...and 语句就是查询的时候按这个范围内条件进行查询的SQL语句
原式=1-1/2+1/2-1/3+1/3-1/4+1/4-1/5+1/5-1/6+1/6-1/7+1/7-1/8+1/8-1/9
=1-1/9
=8/9
1/2+1/6+1/12+1/20+1/30+1/42+1/56+1/72
=1-1/2+1/2-1/3+1/3-1/4+1/4-1/5+1/5-1/6+1/6-1/7+1/7-1/8+1/8-1/9
=1-1/9
=8/9