Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Problems with ROWNUM
Migrateduser
I have a SQL query that returns the top 15 customers. It works fine in Oracle SQL Developer, but when I use the query to create a data set, and generate the report in BIRT, only two rows are returned (2 and 6). If I remove the "where rownum <= 15" filter, all the rows return as expected. I've also tried adding the filter directly in BIRT, rather than coding it directly into the query, but it has the same issue. Has anyone seen something like this happen before?
Find more posts tagged with
Comments
There are no comments yet