CODEWITHSUNDEEP
sqlpostgresqlgroup-by
user46543
user46543

Reputation: 1053

Drop null on group by PostgreSQL

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?

Upvotes: 2

Views: 488

Answers (2)

David Waterworth
David Waterworth

Reputation: 2871

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

Upvotes: 1

Fahmi
Fahmi

Reputation: 37473

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

Upvotes: 1

Related Questions