select t.date,t.user_id,t.pass_count from (select date,user_id,pass_count,row_number()over(partition by date order by pass_count desc) as rk from questions_pass_record)as t where t.rk<=2 "前几名"的问题,可以先用窗口函数排序,作为子函数,在在外部筛选