I WANT TO WRITE A SCRIPT FOR THE TEN BUSIEST DAYS OF THE MONTH BASED ON TRAFFIC.HOW DO I GO ABT IT?
THE SCRIPT BELOW IS FOR THE TEN BUSIEST SITES IN THE MONTH,CAN YOU HELP WITH THAT?
SELECT DATETIME,SITE,TCH_TRAFFIC,RANK
FROM
(
SELECT TRUNC(DATETIME,'MM')DATETIME
,SITE
,SUM(SDCCH_CALL_DROP) SDCCH_CALL_DROP
,SUM(TCH_DROP) TCH_DROP
,ROUND(SUM(TCH_TRAFF),2)TCH_TRAFFIC
,ROW_NUMBER() OVER(PARTITION BY TRUNC(DATETIME,'MM') ORDER BY ROUND(SUM(TCH_TRAFF),2) DESC NULLS LAST) RANK
FROM ZTE_BSS.V_STD_CELLSTATS_DY --,ZTE_BSS.CELLCFG B
WHERE DATETIME BETWEEN TRUNC(SYSDATE,'MM')-3 AND TRUNC(SYSDATE,'MM')-2
--GROUP BY TRUNC(DATETIME,'DD'),CELL--DATETIME,CELL
GROUP BY TRUNC(DATETIME,'MM'),SITE
)
WHERE RANK <=10
ASKED:
Feb 14 2008 4:18 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _