如下:
select count(*) from recv_sms_pool k
where k.recv_time >to_date('2010-06-18','yyyy-mm-dd')
and k.recv_time < to_date('2010-06-19','yyyy-mm-dd')
order by k.rsp_id desc;
我想统计2010.6.7~6.18 每一天的数据 怎么写代码呢 求教
select count(*) from recv_sms_pool k
where k.recv_time >to_date('2010-06-18','yyyy-mm-dd')
and k.recv_time < to_date('2010-06-19','yyyy-mm-dd')
order by k.rsp_id desc;
我想统计2010.6.7~6.18 每一天的数据 怎么写代码呢 求教
FROM recv_sms_pool k
WHERE k.recv_time > to_date('2010-06-18', 'yyyy-mm-dd') AND
k.recv_time < to_date('2010-06-19', 'yyyy-mm-dd')
GROUP BY trunc(k.recv_time)
ORDER BY k.rsp_id DESC;
FROM recv_sms_pool k
WHERE k.recv_time > to_date('2010-06-18', 'yyyy-mm-dd') AND
k.recv_time < to_date('2010-06-19', 'yyyy-mm-dd')
GROUP BY trunc(k.recv_time);
多谢楼上 原来加上trunc就可以啊 呵呵