我在Postgres中有一个查询：
select gender,avg(x) from db where degree = 'NO' group by gender order by gender
由于x列中的某些数据是NaNs。分组依据的结果如下：
'Female','0.12107496463932107496'
'Male','0.09531828898619063658'
null,'0.10851773264625644135'
如何排除最后几行？空吗？
通过PostgreSQL在组上删除null
•
问答
zhuyudiao 回答：通过PostgreSQL在组上删除null
添加条件gender is not null
select gender,avg(x)
from db where degree = 'NO' and gender is not null
group by gender order by gender
我不认为它缺少x值，我认为它缺少性别吗？
select gender,avg(x) from db where degree = 'NO' and gender is not null group by gender order by gender