Answers for "partition by in mysql"

partition by in mysql

select challenge_id, h_id, h_name, score, 
   dense_rank() over ( partition by challenge_id order by score desc ) 
       as "rank", from hacker;

Posted by: Guest on June-09-2021

Code answers related to "partition by in mysql"