如何将单个查询的排名分配给多个列？

Lets say i have int price column in table_1 and i have int priceRank column table_1 again. Now is that possible with single query to order by price desc and assign them their rank via row_number. So the biggest price would get rank 1 and second biggest would get rank 2 and goes on. priceRank column will be updated here via the order of rows returned. How can i do that ? is that possible ? thank you.Lets say i have int price column in table_1 and