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

A

azaza2019-12-08 08:37:49

Opencart owl carousel margin option not working? 2Reply

G

GaserV2017-08-22 21:00:44

How to make a redirect after login to the requested page? 1Reply

K

Konstantin2020-01-28 16:20:04

How to adjust gradient color if only images are given? 2Reply

E

ecnalab2017-09-11 20:34:55

How to implement aligning images into tiles as Vkontakte does? 3Reply

V

VladislavChumak2020-02-27 14:42:09

How to make a unique id/class for a button? 2Reply

Didn't find what you were looking for?

Ask your question