如何写带有行的select max ?

I have a table Final_Table_2, where I used ROW_NUMBER() OVER(PARTITION BY mrID ORDER BY mrID ) AS IDROW_