好吧,我创建了他的查询,拉入两列,但我想要在同一天创建的键数。这是查询:
SELECT TO_CHAR(CAH_MAIN.CREATED, 'DD-MON-YY') AS NSBA_CREATED
, CAH_MAIN.KEY
FROM NSBAS CAH_MAIN;
发布于 2018-08-29 17:09:57
您想要在过去两周内为日期创建的键数。这是一个简单的聚合:
select to_char(created, 'DD-MON-YYYY') as nsba_created
, count(key) as no_of_keys
from cah_main
where created >= sysdate-14
group by to_char(created, 'DD-MON-YYYY')
order by created
/
https://stackoverflow.com/questions/-100002487
复制相似问题