mtn Posted August 26, 2019 Share Posted August 26, 2019 Hi,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,Maartenps. I checked the different db settings.... they are all the same. Link to comment Share on other sites More sharing options...
trvpseudo Posted August 27, 2019 Share Posted August 27, 2019 try to count it, if result is same then its a matter of the data's order Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now