AVG without considering one value?

K

Kirill Zhilyaev2018-04-06 01:17:00

MySQL

Kirill Zhilyaev, 2018-04-06 01:17:00

How to choose the arithmetic mean of a column without considering one value?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

L

Lazy @BojackHorseman MySQL, 2018-04-06
@kirill_782

SUM(CASE WHEN <fieldname> = <значениекотороенеучитывается> THEN 0 ELSE <fieldname> END)
/
SUM(CASE WHEN <fieldname> = <значениекотороенеучитывается> THEN 0  ELSE 1 END)

Similar questions

N

Nastya2020-02-27 13:37:29

How to assign a post of a custom type as the parent page of a post of another custom type, or what to do if you have no experience and half the brain? 4Reply

B

Bohdan Yurchuck2017-12-14 13:27:14

How to find out the IP of a person who entered your site using JS? 6Reply

A

Alexey Korolev2018-01-20 14:31:44

How to make a profile picture on your site using cookies? 1Reply

V

Valery2017-10-07 23:29:56

How to install HandlerSocket in Percona in Docker? 1Reply

E

era-hostingru2017-10-08 17:15:13

Table search (there are 51 of them), how to do it? 1Reply

Didn't find what you were looking for?

Ask your question