SELECT trunc(k.recv_time) ,COUNT(*)
FROM recv_sms_pool k
WHERE k.recv_time > to_date('2010-06-07', 'yyyy-mm-dd') AND
k.recv_time < to_date('2010-06-19', 'yyyy-mm-dd')
--and k.msg_length = 0
GROUP BY trunc(k.recv_time)
order by trunc(k.recv_time)
我想加注释的这行也加进去,同时显示出:时间,总量,长度为空的总量,怎么搞,求教
FROM recv_sms_pool k
WHERE k.recv_time > to_date('2010-06-07', 'yyyy-mm-dd') AND
k.recv_time < to_date('2010-06-19', 'yyyy-mm-dd')
--and k.msg_length = 0
GROUP BY trunc(k.recv_time)
order by trunc(k.recv_time)
我想加注释的这行也加进去,同时显示出:时间,总量,长度为空的总量,怎么搞,求教
FROM recv_sms_pool k
WHERE k.recv_time > to_date('2010-06-07', 'yyyy-mm-dd') AND
k.recv_time < to_date('2010-06-19', 'yyyy-mm-dd')
GROUP BY trunc(k.recv_time)
order by trunc(k.recv_time)