wdl123
- 浏览: 23723 次
- 性别:
- 来自: 杭州
-
文章列表
今天同事遇到一个求时间段的信用值统计，让我花几分钟写出来，不从效率上考虑.基本上是可以实现。为了方便自已记忆，就记录下来
select sum(a1),sum(a2) from (
select if(to_days(now())-to_days(ltime)<7,1,0) as a1,if
(to_days(now())-to_days(ltime)<30,1,0) as a2,appraise
from leaveword_po
) as ttt
group by appraise
- 2009-02-11 17:01
- 浏览 950
- 评论(0)