Different results



In a report I'm using a SQL query to retrieve the necessary data. Using the identical query in both tools I'm getting different results in SQL developer and Jaspersoft. Can someone point me in a possible direction of what is going on? I have to mention that the query performed is large (execution time 40 seconds +); maybe of relevance.

So my main question is what can be causing the differences in results?

Kind Regards,


ps. I checked the different db settings.... they are all the same.



mtn's picture
Joined: Aug 22 2017 - 4:41am
Last seen: 5 months 6 days ago

try to count it, if result is same then its a matter of the data's order

trvpseudo - 11 months 3 weeks ago

0 Answers:

No answers yet