Select count row. Partition by order by. over partition by. row_number() over (partition by. partition by sql.