SELECT date,user_id,pass_count FROM ( SELECT user_id, pass_count, date, row_number () over ( PARTITION BY date ORDER BY pass_count DESC ) rk FROM questions_pass_record ) AS t1 WHERE rk <= 2