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

S

strelkovandreyv2019-09-10 07:09:07

What is the PHP file manager with the ability to connect via SMB to Windows share? 2Reply

M

matros972017-04-20 10:07:09

The text does not fit into the block? 4Reply

F

Flanker3812015-05-28 16:54:35

Debian netstat output. What do the lines mean? 6Reply

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

Didn't find what you were looking for?

Ask your question