MySQL get sum of all values without sign?

X

XenK2016-07-14 08:11:21

MySQL

XenK, 2016-07-14 08:11:21

There is a column "money", it has negative and positive values, it is necessary to calculate the sum of all entries, without taking into account the sign. What is the best way to do this?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Maxim Fedorov, 2016-07-14
@XenK

SELECT SUM(ABS(fieldname)) FROM tablename

Similar questions

R

Roman Tuzov2021-03-22 23:47:34

How to count from 0 and beyond? 3Reply

A

Anton2021-03-27 12:39:53

Getting the selected radio item and passing it to the email body, how to display the selected item? 2Reply

G

GRO242019-10-20 17:02:09

Writing a loop to a variable? 2Reply

Z

zhandosbai2015-06-24 21:12:30

User region specifier for Yii, which one to choose? 3Reply

Q

Questions00012021-05-07 16:07:05

How to bypass intrusive Youtube ads? ad blockers don't help. You need to switch to a paid plan to stop ads. What can be done? 4Reply

Didn't find what you were looking for?

Ask your question