SQL database query A table create a new sort field and store sorted values based on the sort of a column

Now there is a table as follows
Id Name Age classify score
1 1181 Class 12
2 2,172 class 19
3 3,193 Class 30

I'm going to rank them according to their scores. Create a new column store sort values
The->sql statement is as follows
Select Row_number () over (order by score ASC) as Number,id,name,age,classify,score
From U_college order by score;
The resulting effect is as follows
Numberid Name Age classify score
13 3,193 Class 30
22 2,172 Class 19
31 1181 Class 12
END;

SQL database query A table create a new sort field and store sorted values based on the sort of a column