pelegk2 Posted December 18, 2003 Share Posted December 18, 2003 am doing SELECT SUM(\'val\') as xx from mydata where val is of type float even when i do this on mySql i get 0 as the total value!!!! why? (i dont have negative numbers thanks in advance peleg ?>[/code] Quote Link to comment Share on other sites More sharing options...
shivabharat Posted December 18, 2003 Share Posted December 18, 2003 Try it this way SELECT SUM(val) as xx from mydata You shouldn\'t use the quotes. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.