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

Y

Yaroslav2019-10-03 12:49:21

Where and how to find free labor for the for fun project and where to discuss ideas? 7Reply

Z

zhandosbai2015-06-24 21:12:30

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

D

Dima Pautov2015-06-29 19:52:05

How to smoothly scroll the page to the desired id by going to it from another page? 2Reply

W

WWK_12021-05-06 22:06:05

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

R

ReD2017-06-20 15:59:52

mod_rewrite module is now integrated into Apache? 2Reply

Didn't find what you were looking for?

Ask your question