How to display a certain number of rows from a table in decreasing order of one of the values?

Question

MySQL

The table has multiple rows. Each row has a value in the type column from 1 to 10. How to display them in descending order, that is, all rows with a value of 10 would be displayed first, then 9, and so on.

Answer 1

SELECT * from table_name ORDER BY `type` DESC