新手求助：Postgresql求每一列占该行总数的比例

[ylda117]

例如有如下列

我想对每个s_id求每一列（age_19_29, age_29_39等）占整个行所有年龄段加和的比例，
也就是
age_19_29/(age_19_29+age_29_39+age_39_49+age_49_59) = ？
谢谢解答！！

[doris_d]

查询所有：select age_19_29*1.0/(age_19_29+age_29_39+age_39_49+age_49_59) from a;
查询指定s_id：select age_19_29*1.0/(age_19_29+age_29_39+age_39_49+age_49_59) from a where s_id=38859;

[ylda117]

引用 1 楼 doris_d 的回复:

查询所有：select age_19_29*1.0/(age_19_29+age_29_39+age_39_49+age_49_59) from a; 查询指定s_id：select age_19_29*1.0/(age_19_29+age_29_39+age_39_49+age_49_59) from a where s_id=38859;

谢谢回复，懂了