daveschultz
Well Known Member
I am using BI Publisher Enterprise edition. I would like to get a list the units that have the top 20 number of work orders. I am trying to use a SQL statement like this
select * from (
select count(F4801.DOCO) as DOCO,
F4801.NUMB as NUMB
from JDE.F4801 F4801
group by F4801.NUMB)
where rownum <= 20
It works when I run it through TOAD, and it works in BI publisher if I run it without the outside select and rownnum. Any idea how to accomplish this?
Dave
E8.12, Tools 8.98.1.4, Oracle 10g
select * from (
select count(F4801.DOCO) as DOCO,
F4801.NUMB as NUMB
from JDE.F4801 F4801
group by F4801.NUMB)
where rownum <= 20
It works when I run it through TOAD, and it works in BI publisher if I run it without the outside select and rownnum. Any idea how to accomplish this?
Dave
E8.12, Tools 8.98.1.4, Oracle 10g