This function works on 8i? PERCENTILE_CONT

[isonlyme]

Hi All

does this function works on 8i PERCENTILE_CONT?

I have this error when running

SELECT BR,
ACCT_PROD,
AVG_BOOK_BAL,
PERCENTILE_CONT(0.5) WITHIN GROUP
(ORDER BY (AVG_BOOK_BAL)) OVER (PARTITION BY (BR))
FROM IATMDC
WHERE DATA_SRC_CD IN ('IM','ST')
AND AS_OF_DT = to_date('01-31-2005', 'mm-dd-yyyy')
AND BR IN (11,13)
AND ACCT_PROD = '021'
GROUP BY BR,
ACCT_PROD

PERCENTILE_CONT(0.5) WITHIN GROUP
*
ERROR at line 4:
ORA-00923: FROM keyword not found where expected


Thanks in advance!!!!

 

[dbtoo2001]

I don't think so.

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/function.htm#81409