AVG without considering one value?

K

K

Kirill Zhilyaev2018-04-06 01:17:00

MySQL

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

AVG without considering one value?

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

Reply

Answer the question

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

A

alexalexov20192020-03-06 13:20:25

When I work for upwork through an agency, will my hours be kept after I leave the agency? 2Reply

D

Denis2017-11-01 00:03:54

What should module 'csv' has no attribute 'writer' do? 3Reply

N

Nikita Andreevich2020-03-29 01:25:30

How to find companies that deal with relaunch in the USA? 2Reply

H

Hanry6542020-04-09 07:38:28

How to make modal window [fullscreen] only open up to half of screen size in vuetify? 3Reply

A

Andrew2017-12-22 21:43:36

How to connect payment to the site? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question