Select the top 10 objects

Question

There is a table with many entries. How to choose from the table the 10 most expensive products?

id | product | price

angry

5,855 15 gold marks 57 silver marks 171 bronze marks

Jl

89 3 silver marks 21 bronze marks

|

1 answer 1

Zowie zowie 12.7k 15 silver marks 38 bronze marks · Accepted Answer · 2011-10-09T10:46:38

Create a view and you will be happy ... The request itself:

SELECT * FROM table ORDER BY price DESC LIMIT 10;