Drop null on group by PostgreSQL

Question

I have a query in Postgres:

select gender, avg(x) from db where degree = 'NO' group by gender order by gender

Due to some data in x column are NaNs. The result of the group by looks like:

'Female','0.12107496463932107496'
'Male','0.09531828898619063658'
 null,'0.10851773264625644135'

How to exclude the last rows? the null?

Fahmi · Accepted Answer · 2019-11-06 05:42:43Z

1

Add a condition gender is not null

select gender, avg(x) 
from db where degree = 'NO' and gender is not null
group by gender order by gender

answered Nov 6, 2019 at 5:42

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Waterworth · Accepted Answer · 2019-11-06 05:43:16Z

1

I don't think it's missing x values, I think it's missing gender's?

select gender, avg(x) from db where degree = 'NO' and gender is not null group by gender order by gender

answered Nov 6, 2019 at 5:43

David Waterworth

2,9631 gold badge26 silver badges55 bronze badges