You can also write this procedure without a loop by adding an ORDER BY value DESC clause to the SELECT statement.

• 您还可以通过将ORDER BY值DESC子句添加到SELECT语句中,不借助循环编写此过程。