Hi All,

When I tried to compile the below statement
SELECT * FROM
(SELECT count(*) ,work_type, flt_code
FROM WKAW
WHERE (org_date >=:FromDate AND org_date <=:ToDate)
GROUP BY WORK_TYPE,flt_code
ORDER BY count(*) DESC)
WHERE rownum <11

system prompt me message " The order caluse is invalid in views, inlinefunction etc..."

Please advise
Thank you.

Tomms