一些常用SQL

--按时间区间分组查询
--以下是按照CHECK_TIME每10分钟一组进行分组
SELECT
  count( 1 ) count,
	to_char(CHECK_TIME,'yyyy-MM-dd hh24')||':'||lpad(floor(to_char(CHECK_TIME,'mi')/10)*10,2,0) 打卡时间
FROM
  HRMS_ATT_CHECK_DATA 
WHERE
  TO_CHAR( CHECK_TIME, 'yyyy-MM-dd' ) >= '2021-12-03' 
GROUP BY
 to_char(CHECK_TIME,'yyyy-MM-dd hh24')||':'||lpad(floor(to_char(CHECK_TIME,'mi')/10)*10,2,0) 
ORDER BY
  MIN( CHECK_TIME )