var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: can't execute query with PERCENTILE_DISC
I am using oracle 8i enteprise edition ver 8.1.6
I'm trying to execute the query below:
SELECT PERCENTILE_DISC (0.5) WITHIN GROUP (ORDER BY a.time_duration) AS kkk
FROM v_user_time_duration a
and I get this error:
ora-00923:from keyword not found were expected.
what is the problem ?
oracle in this version can execute that query?
I'm afraid your DB version is too low ... this analytic function is added in Oracle9i.
Last edited by Littlefoot; 08-10-04 at 05:21.