Amigos, tengo una duda:
SELECT TRUNC (HORAINICIO) FECHA1, CAUSATERMINO,
COUNT (STATUS) TOTAL,
FIRST_VALUE(COUNT (STATUS)) over(partition by TRUNC (HORAINICIO) order by COUNT (STATUS) DESC) ORDEN
FROM VAS.CDR_DATA_USSD
WHERE TRUNC (HORAINICIO) >= TRUNC (TO_DATE ('12/03/2019', 'dd-mm-yyyy'))
AND TRUNC (HORAINICIO) <= TRUNC (TO_DATE ('18/03/2019', 'dd-mm-yyyy'))
AND CODIGOSERVICIO <> 111
AND CAUSATERMINO NOT IN ('0')
GROUP BY TRUNC (HORAINICIO), CAUSATERMINO
ORDER BY TRUNC (HORAINICIO), TOTAL DESC
SELECT TRUNC (HORAINICIO) FECHA1, CAUSATERMINO,
COUNT (STATUS) TOTAL,
FIRST_VALUE(COUNT (STATUS)) over(partition by TRUNC (HORAINICIO) order by COUNT (STATUS) DESC) ORDEN
FROM VAS.CDR_DATA_USSD
WHERE TRUNC (HORAINICIO) >= TRUNC (TO_DATE ('12/03/2019', 'dd-mm-yyyy'))
AND TRUNC (HORAINICIO) <= TRUNC (TO_DATE ('18/03/2019', 'dd-mm-yyyy'))
AND CODIGOSERVICIO <> 111
AND CAUSATERMINO NOT IN ('0')
GROUP BY TRUNC (HORAINICIO), CAUSATERMINO
ORDER BY TRUNC (HORAINICIO), TOTAL DESC