0

+----------+---------------------+------------+--------------------+
|wage_id | full_name | wage | date_added |
+----------+---------------------+------------+--------------------+
| 1 | Unknown | 123 | 2001-12-22 |
+----------+---------------------+------------+--------------------+
| 2 | Unknown2 | 321 | 2007-06-17 |
+----------+---------------------+------------+--------------------+

how to count sum pf values in wage column?
123+321= 444 <---- that way :)

2
Contributors
3
Replies
7
Views
10 Years
Discussion Span
Last Post by iamthwee
0

+----------+---------------------+------------+--------------------+
|wage_id | full_name | wage | date_added |
+----------+---------------------+------------+--------------------+
| 1 | Unknown | 123 | 2001-12-22 |
+----------+---------------------+------------+--------------------+
| 2 | Unknown2 | 321 | 2007-06-17 |
+----------+---------------------+------------+--------------------+

how to count sum pf values in wage column?
123+321= 444 <---- that way :)

Thank you for help, i've found the answer :


mysql> select sum(wage) from name_of_table;
+------------+
|sum(wage)|
+------------+
| 444 |
+------------+

:$ it was simple :$

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.