I've filed named Point
I want to count all the filed value ( the total value not the total filed number )
can I do it by using simple SQL query ? or should I do while statment to get it manually
How can I count DB filed value ?
Moderator: General Moderators
-
Supper Baby
- Forum Commoner
- Posts: 27
- Joined: Tue Aug 01, 2006 11:33 pm
-
Supper Baby
- Forum Commoner
- Posts: 27
- Joined: Tue Aug 01, 2006 11:33 pm
Code: Select all
id point
1 10
2 10
3 10
4 5
5 10-
Supper Baby
- Forum Commoner
- Posts: 27
- Joined: Tue Aug 01, 2006 11:33 pm
Code: Select all
SELECT sum(point)
FROM yourtable;