摘要：ROW_NUMBER() over(partition by 分组字段 order by 排序字段) select *, ROW_NUMBER() over(partition by user_id order by is_main_post desc,enable_time) as t FROM 阅读全文