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

N

NyxDeveloper2021-05-04 16:15:55

How to forbid assigning id to fields of ForignKey of that object, whose certain field is equal to False? 4Reply

W

WWK_12021-05-06 22:06:05

Is it possible and how to set up Prettier? 1Reply

A

Alexander Reshetnyak2017-06-17 19:35:05

Which Blender plugin is better for creating sprites for games? 1Reply

D

DR_Demons2015-07-19 16:58:45

What is the actual size of the directory? 3Reply

N

Nikolai Steshenko2021-05-24 00:59:15

How to add a field to registration or remove instantaCms? 2Reply

Didn't find what you were looking for?

Ask your question