我需要拉出每个班次创建的票据总数以及运行总数。我有一个现有的查询,我认为它是正确的,但经过检查,它似乎拉错了数字。
SELECT
TO_CHAR(TRUNC(DTTM,'Y'),'YYYY') as "DATE"
,COUNT(CASE WHEN TO_CHAR(DTTM, 'HH24:MI') BETWEEN '14:00' AND '22:00' THEN TKTNUM ELSE NULL END) AS "DAYS"
,COUNT(CASE WH
oracle.xdb.XMLTypeFactory.create(XMLTypeFactory.java:74) at oracle.sql.OPAQUE.toClass(OPAQUE.java:376)在oracle.sqloracle.jdbc.driver.NamedTypeAccessor.getObject