Oracle sql 统计
时间：2021-07-01 10:21:17
帮助过：4人阅读
TO_CHAR(RECEIVE_TIME,
‘HH24‘) HOUR ,
COUNT(
*) N
FROM PH_PRESCRIPTION P
WHERE TO_CHAR(P.RECEIVE_TIME ,
‘YYYY-MM-DD‘)
=‘2018-12-05‘
GROUP BY TO_CHAR(RECEIVE_TIME,
‘HH24‘)
ORDER BY TO_CHAR(RECEIVE_TIME,
‘HH24‘);
Oracle sql 统计
标签：计数 res rip select esc span time oracl sql
