URGENT HELP: SELECT STATEMENT????
Posted: Thu Dec 11, 2008 2:54 pm
Hi,
I have a select statement like below:
Add from month 1 to month 11
=========================
SELECT SUM(monthly_target_1) + SUM(monthly_target_2) + SUM(monthly_target_3) + SUM(monthly_target_4) + SUM(monthly_target_5) + SUM(monthly_target_6) + SUM(monthly_target_7) + SUM(monthly_target_8) + SUM(monthly_target_9) + SUM(monthly_target_10) + SUM(monthly_target_11) FROM target WHERE platform_code = 'B'
Problem: it return the value as 0, but if I take out one field, then it is working, it seems a limitation or something.
If I take out month 11, IT WORKS - add from month 1 to month 10
=========================================
SELECT SUM(monthly_target_1) + SUM(monthly_target_2) + SUM(monthly_target_3) + SUM(monthly_target_4) + SUM(monthly_target_5) + SUM(monthly_target_6) + SUM(monthly_target_7) + SUM(monthly_target_8) + SUM(monthly_target_9) + SUM(monthly_target_10) FROM target WHERE platform_code = 'B'
Is that any limitation on select statement only allow # of fields with SUM() function?
Is that a max. # of characters in one select statement?
How can I get around this?
Thanks
I have a select statement like below:
Add from month 1 to month 11
=========================
SELECT SUM(monthly_target_1) + SUM(monthly_target_2) + SUM(monthly_target_3) + SUM(monthly_target_4) + SUM(monthly_target_5) + SUM(monthly_target_6) + SUM(monthly_target_7) + SUM(monthly_target_8) + SUM(monthly_target_9) + SUM(monthly_target_10) + SUM(monthly_target_11) FROM target WHERE platform_code = 'B'
Problem: it return the value as 0, but if I take out one field, then it is working, it seems a limitation or something.
If I take out month 11, IT WORKS - add from month 1 to month 10
=========================================
SELECT SUM(monthly_target_1) + SUM(monthly_target_2) + SUM(monthly_target_3) + SUM(monthly_target_4) + SUM(monthly_target_5) + SUM(monthly_target_6) + SUM(monthly_target_7) + SUM(monthly_target_8) + SUM(monthly_target_9) + SUM(monthly_target_10) FROM target WHERE platform_code = 'B'
Is that any limitation on select statement only allow # of fields with SUM() function?
Is that a max. # of characters in one select statement?
How can I get around this?
Thanks