想要分别统计不同性别权重最高的用户咋办呢？废话不多说，直接上查询语句：
ROW_NUMBER() OVER(
[PARTITION BY column_1, column_2, …]
[ORDER BY column_3, column_4, …]
)
# 子查询，用来分组统计表
sub = select row_number() over(partition by sex order by weight desc) as grp_row_id,* from users;
select * from (sub) temp where temp.grp_row_id=1;
