My sql query is running fine but when I export the data to excel it gives warning : null value is eliminated by an aggregate or other SET operation. How to fix this issue?
2
-
1If you could post your query we may have a better chance at answering.Rich Benner– Rich Benner2016-06-09 07:49:15 +00:00Commented Jun 9, 2016 at 7:49
-
Maybe you should post the query? How shall we know what you are trying to do if you just tell us that error message..Mono– Mono2016-06-09 07:49:43 +00:00Commented Jun 9, 2016 at 7:49
Add a comment
|
1 Answer
Really it's just a warning indicating some aggregated data are NULLs. For example average of {10, null, 20} is (10+20)/2=15, null is totally ignored. If it's OK, just ignore the warning or set ansi_warnings off to turn it off. Otherwise check your data for NULLs or change the query accordingly.
