![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Tue, Aug 26 2008 8:37 AM | Permanent Link |
Heiko Knuettel | SELECT
AVG(field)+1, STDDEV(field)+1, RUNSUM(field)+1, MIN(field)+1, MAX(field)+1, COUNT(field)+1, SUM(field)+1 FROM table AVG, STDDEV and RUNSUM always result in null. The rest works. Heiko |
Wed, Aug 27 2008 1:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Heiko,
<< SELECT AVG(field)+1, STDDEV(field)+1, RUNSUM(field)+1, MIN(field)+1, MAX(field)+1, COUNT(field)+1, SUM(field)+1 FROM table AVG, STDDEV and RUNSUM always result in null. The rest works. >> This is now fixed for the next build. The issue is that the binary +1 expression is being evaluated prior to the AVG() being evaluated, thus resulting in the NULL. This basically causes any of the aggregates that work on the basis of a calculation (AVG=SUM/COUNT) to have this issue. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |