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

Rooly2021-03-23 11:40:40

How to properly organize apiResource Laravel? 2Reply

S

strelkovandreyv2019-09-10 07:09:07

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

T

Timofey Belousov2015-05-12 23:15:48

Where and how to convert a png file to cur? To set the cursor on the site? 5Reply

G

gargamel12021-04-18 00:54:18

Working with multiple telebot keyboards? 1Reply

H

Hikanosu2021-05-04 17:22:30

AIOgram, what is the best way to update the mailing code so that it does not stop due to Flood control? 2Reply

Didn't find what you were looking for?

Ask your question